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:
[color=blue]
> 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[/color]
--
--------------------------------------
Chris Moore
cdmwebs [at] no_spam_hotmail [dot] com
http://cdmwebs.com 
