Need Sub form combo boxes to update form combo boxes

I tried doing this once before, and could not get it to work so I just
proceeded in the old fashion way (adding new business to the subform combo
box, closing the main form, reopening the form, then reopening the combo box.)

I had a few minutes and decided to try to write a macro (I do not write
code) and then put it in the After Update field.

Here is what I have:

Two sub forms on my main form. Each sub form has one combo box. I can update
my tbl_business and/or my tbl_description by using these two sub form combo
boxes.

I wrote a Macro "Macro_AddNewBusiness" to simply say "Open Table" - "Table
Business" On the After Update line of the combo box on the sub form and the
main form, I entered the Macro Name "Macro_AddNewBusiness."

On the subform, after I add the new business, the table immediately appears
and I have to close it.

When I click the combo box on the main form, the combo box list appears. I
choose the name, then the actual table appears. I have to highlight or point
to the business I want, then I have to close the table for the new business
to appear as the correct business choice in the combo box on the main form.
This happens if I want to enter a business that has been on the list prior to
a new addition.

Needless to say, I don't think I'm doing this correctly. What should I be
doing? Any suggestions as I know all this would be a great time saver if I
can get it to work.


Thanks in advance