By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,043 Members | 1,275 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,043 IT Pros & Developers. It's quick & easy.

Update combobox from table.

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.