Combo list not updating with new records

[Guest]

I have a problem with a combo list being updated with new records. While
creating a new project record in the projects form, users can open a contacts
form and create a contact if the required contact doesn't appear on the combo
list in the projects form....I hope that make sence?

Once the contact has been added, users close the contacts form and go back
to their new record on the projects form. The line below should update the
combo list, but it doesn't.The gotfocus is on the form, not on the control
itself. Could someone please help?

Private Sub Form_GotFocus()
Me.cboContactID.Requery

Regards,
Glenn

 

[Guest]

Hi Glenn,

Put the requery into the close button of the new contact form like this:

forms!MAINFORMNAME.cboContactID.requery

Hope this helps.

Damian.