Pop-up Window from a check box

Hi,

I am creating a database to manage inventory at the chemistry lab that I work in.

I have it set up that when we receive in new stock the employee goes to the database. I have a layout that lists all of the chemicals that have been ordered but not yet received. The employee then clicks the checkbox for received.

I would like it so that when the "received" checkbox is clicked that a window pops up that asks displays information from another table. This second table has drop downs about storage location and what happens to the invoices.

The employee then closes the window and the information is stored in that table and then there done. Does anyone know how to script this?

Thanks

js22

Edited December 22, 200619 yr by Guest