Requery Combo box in subform.

Joined
Jul 1, 2008
Messages
1
Reaction score
0
I have a main form which has 3 subform within it and all work correctly except 1.
  1. In the subform there is a combo box to select the document type you are entering in that subform.
  2. If the document type you require is not listed then you can click a command button which takes you to a blank form where you can enter your new document type.
  3. On closing, the focus is returned to the previous form and you can then click the combo box in the subform but the new entry is not there.
  4. I have a refresh button on the main form but this does still not show the new entry in the list.
  5. However if you close the form and reopen it your new data in the combo list will be visible.
  6. How can I refresh the combo list without having to exit and reopen?
Kind Regards

JH
 
Back
Top