Search Main form from sub form

[nrog]

I have a customer form. The main part of the form (customer) has the basic information about the company. It has a subform with the various addresses on it. This all works fine (very basic).



I have another subform on it (company_list) that is not linked. It will list all the companies and their region in a list form going down one side of the form.

What I would like to do is click on the company I want in the subform and it pulls up the record in the main form, but I can't seem to figure out how to do it.

[pbaldy]

You should be able to adapt this, but without the OpenForm:

http://www.baldyweb.com/Bookmark.htm

[nrog]

You should be able to adapt this, but without the OpenForm:

http://www.baldyweb.com/Bookmark.htm

I was able to adapt the code and it succesfully located the record and then replaced the key field (mine is a text field) with the correct information from the subform. However, it did not retrieve the record and only acts as though I am trying to change the field for the existing record on the form.

[pbaldy]

Can you post the db here, or a representative sample?