DoCmd.Requery

[swenger]

I have a form with a combo box which looks up info from another table. If the record I am looking up doesn't exist I created an event on double-click of the combo box to open a form which shows the records from the table and create a new record. On the close event of this pop-up form I enetered DoCmd.Requery, however when I close this form I get a message "The command or action 'Requery' isn't available now."

[swenger]

Perhaps I have the wrong syntax

Private Sub Close_Click()

Frm = frmDetails 'Frm was declared as Public already

DoCmd.Close
DoCmd.Requery Frm

End Sub

[swenger]

Figured it out.

Forms!frmDetails!CustomerCombo.Requery

I was requering the data source of the table, but should be requerying the combo box.