How refresh combo box ?

[David]

I have a tabbed form. Each tab contains a subform.
One tab contains a combo box and the table on which the
contents are based can be updated from another tab.

I have noticed that when I add a new record, then go back
to the other tab, the new item is not in the combo drop
down. Also, if I delete an item, the combo box
shows '#Deleted' in the drop down. How to fix this?

I need to refresh the combo box in certain circumstances.
How do I do this? How do I refer to a combo box in a
subform in a tab from another subform in a different tab?
The VBA prompts were of no help.

 

[Scott McDaniel]

To refer to controls on a subform, use syntax like this:

Forms!NameOfMainForm.NameOfSubformCONTROL.Form.NameOfControl

The tricky part is remembering to use the name of the subform Control ...
which is usually NOT the name of the subform itself.