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

update combo box

P: n/a
I have two synchronized combo boxes and after the selection of the
desired record, I need the user to open the related report, by
pressing a button.

My problem is that a combo box doesn't update do the first one. The
record are correct, but the first one is always from the last
selection. How can I update the second combo box?

Thanks

Maria Joao
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In article <e2*************************@posting.google.com> ,
sa*******@yahoo.com says...
I have two synchronized combo boxes and after the selection of the
desired record, I need the user to open the related report, by
pressing a button.

My problem is that a combo box doesn't update do the first one. The
record are correct, but the first one is always from the last
selection. How can I update the second combo box?

Thanks

Maria Joao

Not sure I follow what you are asking. Your question is rather unclear.
However if you want the list of options in one combo box to be
determined by the selection in another combo box you merely need to use
an event on the 1st combo box to change the Row Source of the 2nd combo
box. The On Change event will cause the Row Source to change every time
the user changes the selected value in the 1st box. In addition to
writing code to change the Row Source you will most likely want to add a
bit of code to assign the 1st item in the new list as the selected item.
DB
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.