Updating a query that a combo box is based on

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has 2 combo boxes at the start.

The first box looks up a product code. The second then looks up serial
numbers.

I want the second box to be limited by what was entered into the first one.
To do this I set the second box to lookup a query that has the criteria to
only show the serial numbers if their product code is the same as that on the
form.

This works great the first time, but after that the list for the second box
never changes regardless of what you put in the first box.

What am I doing wrong?
 
Keith said:
I have a form that has 2 combo boxes at the start.

The first box looks up a product code. The second then looks up serial
numbers.

I want the second box to be limited by what was entered into the first one.
To do this I set the second box to lookup a query that has the criteria to
only show the serial numbers if their product code is the same as that on the
form.

This works great the first time, but after that the list for the second box
never changes regardless of what you put in the first box.
Click to expand...


The first combo's AfterUpdate event procedure needs to
requery the second combo. Most likely, the form's Current
event procedure also need to requery the second combo box.
 
Back
Top