Z
znibk
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
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