List box Double Click Event

P

Playa

When I double click a record in my list box I want a new form to open,
showing its related records in a list box.

For example...

I double click a record containing a MachineNumber(primary key) from one
list box.

New Form Opens, with a new list box contianing all Drawing Numbers that are
associated with the MachineNumber(foreign key) that was double clicked above.

I can't figure out how to get this to work, I tried it with code and using
criteria in a query but both were no go's. Any ideas??

Thanks
 
Top