refreshing combo values

[Cereldine]

From my main form i have a pop up form that allows user to enter data into the one side of a relationship.

When the form is closed i want to refresh the form that called it so the value can be selected from a combo box.

Is it not something simple along the lines of

Me.Visible = False
DoCmd.OpenForm "document_entry"
Form.Refresh

 

[Mile-O]

Me.MyCombo.Requery

 

[Cereldine]

do you have to set the focus to the main form first?

 

[Mile-O]

do you have to set the focus to the main form first?

If you are closing the form, as you have said, then I would have thought the focus would return to an active control on that form.

If you want to requery from the other form before you close it then:

Forms("FormName").ComboName.Requery