Combo Box lookup stops working.

[RPM1996]

I am attempting to to add some features to an exsisting db. My Main form
displays a family last name. On a tabbed control there is a subform to add
family members to the general last name. I created a family lookup combo box
using the wizard. This control works fine. I also need to be able to search
for a first name that could appear in the subform. I created a form (named
LookupForm) that displays all of the first names from the bound table. When
a first name is selected in the combo box there is a button labled "Go to
first Name". The "On Click" event opens the Main form to the selected name,
clears the combo box, and closes the "LookupForm". All of this works well.
The issue is that after the variable is sent to the "Main" form the Family
name lookup no longer functions until the Main form is closed and reopened.
Is there a way to reactivate the family lookup with out closing the Main form?

Access 2000 db running in Access 2003.
Thank you in advance. Rick

 

[Mike Painter]

There is no reason why your combo box can't provide last and first names.
Base it on a query joining the last name and first name tables.
Having once worked in a store with two Donald Leroy Smiths, you will need
more than just last and first anmes to make sure the new names are added
correctly.