Finally got my code to work for creating a new record and have used the refresh option to update the combo box to display the business name just created.
The problem is, is that after selecting the business name from the combo box, the associated record won't display in my MEMBERS form.
Only after I close the form and reselect it again, does the new business name populate after it has been selected via the combo box again.
Am I missing a step somewhere to refresh the records associated with this table?
Do I need to refresh the initial query that I used to create the form with?
If so, how can this be accomplish via VB code?
Thx...CementCarver