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]

Re: Update combobox from table.

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.cboTheComboB ox.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