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

Automatic reloading of the combobox requests in a form

P: n/a
How can I save new values in a table and directly see it in a form
combobox without closing and re-opening the form and without losing
the entered values?
The second use is to do a request including a value from a listbox (or
a listbox):
ex: values find in a combobox from Table/request : SELECT
table1.field1 FROM table1 WHERE table1.champ2 = comboxbox2.value

In fact, this example work only one time, and if I choose another
value in the combobox2, the values list of the first one didn't
change.

Therefore, what is the solution?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
To achieve this, enter the records into a form, not directly into your
table.

In the AfterUpdate event of the form, requery the combo:

Private Sub Form_AfterUpdate()
Forms![NameOrYourOtherFormHere]![NameOfYourComboHere].Requery
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Franck Foschiatti" <f.**********@ifrance.com> wrote in message
news:d0**************************@posting.google.c om...
How can I save new values in a table and directly see it in a form
combobox without closing and re-opening the form and without losing
the entered values?
The second use is to do a request including a value from a listbox (or
a listbox):
ex: values find in a combobox from Table/request : SELECT
table1.field1 FROM table1 WHERE table1.champ2 = comboxbox2.value

In fact, this example work only one time, and if I choose another
value in the combobox2, the values list of the first one didn't
change.

Therefore, what is the solution?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.