Update combobox from table.

[Lumpierbritches]

Thank you in advance for any assistance, it is greatly appreciated. I would
like to know if there's a way to update a combobox that is on a form when the
table that it's linked to is updated, with the form still open?

I have multiple comboboxes linked back to other tables and as a user
double-clicks on the combobox, a form for updating that table is opened. The
problem I have is that the updated listing isn't available in the combobox
selection until the form with the combobox is closed and reopened. (a pain)

Michael

[Chris Moore]

If you're returning the focus to the form, put this code in the form's
activate event. Otherwise you'll need to add a "Requery" button or
something.

Private Sub Form_Activate()

Me.cboTheComboBox.Requery

End Sub

Lumpierbritches wrote:

Thank you in advance for any assistance, it is greatly appreciated. I would
like to know if there's a way to update a combobox that is on a form when the
table that it's linked to is updated, with the form still open?

I have multiple comboboxes linked back to other tables and as a user
double-clicks on the combobox, a form for updating that table is opened. The
problem I have is that the updated listing isn't available in the combobox
selection until the form with the combobox is closed and reopened. (a pain)

Michael

--
--------------------------------------
Chris Moore
cdmwebs [at] no_spam_hotmail [dot] com
http://cdmwebs.com