Hi there. I have a large form. Within that form there is a field where a user needs to enter a client contact name. If the name is currently not in the drop down (the related table) I would like them to be able to double click on the field and have the form pop up to enter the new client contact name.
I have the macro to open the form on doubleclick event. Works fine. However, you have to close the main form in order for it to appear. Is there a way to requery so the new addition to the client contact table appears?
In my macro I have OpenForm and then Requery, but it is not working. I seem to be missing a step.
I do not want my users to have to close the main form and come back into it in order to add a new name?
Any help would be greatly appreciated.
Cindy
I have the macro to open the form on doubleclick event. Works fine. However, you have to close the main form in order for it to appear. Is there a way to requery so the new addition to the client contact table appears?
In my macro I have OpenForm and then Requery, but it is not working. I seem to be missing a step.
I do not want my users to have to close the main form and come back into it in order to add a new name?
Any help would be greatly appreciated.
Cindy
