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