linking a form by main form's listbox column (0) value

L

lp

Hi - I have a main form that has a listbox. When the user double-clicks on a
record in the listbox I would like my edit info window to open (with the
record info. in the edit info window fields)... how do i go about this. .i
have tried linking the 2 forms by running a macro in the main form's on
current event (i had the macro opening up my edit info page.. this didn't
work). Should i be going about this a different way? I would also like the
user to be able to change any info. on my edit info window. The information
for my edit info window comes from 3 different tables (so i was thinking i
should set up a query to pull this). Any direction would be greatly
appreciated.
 
Top