Double Click a listbox to return record information to another form

[spnz via AccessMonster.com]

Hi there

I have seen before where someone has created a userform used for searching.
The results of the seach are displayed in a listbox. By double clicking on
the the required record in the listbox all data for that record is passed
back to a main form.

Can anyone help out in a way so I can do the same.

I have created a main form and also the form for searching. But I have no
idea on how to pass the information from the searchform into the main form.


Any ideas would be most helpful

Thanks for your time.

 

[Graham R Seach]

This is one way:
http://www.pacificdb.com.au/MVP/Code/MyDialog.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)