Macro

[Sharon]

I have a form with many tabs. I have fields that get
inventors' names from the inventor tables in a drop down
list. I have a created button to enter a new name
(because it is not on the list yet), which works just
fine, I am able to select the button and it allows me to
enter the form to add a new inventor's name and other
information. However, when I exit the inventor form and
try and select in the dropdown list, it is not there. I
have to exit the form and go back into it in order for it
to add the name. What do I do?

 

[Steve Schapel]

Sharon,

Try using a macro with the Requery action applied to the combobox. You
could assign such a macro on the On Activate event of your main form, or
the Close event of the form you use to add the new inventor.