refreshing my form

[Guest]

hey all,

i have a form with a drop down list on it. if i double-click on it it brings
up another form where i can add/edit the contents of my drop-down list.

however, when i edit the items of the drop-down list and close that form and
come back to main form the drop-down list hasn't changed. if i close that
form and come back into it it looks fine then; all the changes are propagated
only then.

can someone please tell me what i need to do to fix this?

thanks,
rodchar

 

[Guest]

On the unload event of form2, run the code that refresh the list on form1
Forms![From1Name]![ListName].requery

 

[Allen Browne]

Use the AfterUpdate event of the 2nd form to requery the combo in the
original form:

Private Sub Form_AfterUpdate()
Forms!Form1!Combo1.Requery
End Sub

You probably want to do that in Form_AfterDelConfirm as well.