combo box limited to matching criteria

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

Guest

Each customer has multiple stores & I want the user to see only the stores
for the customer they have selected from another combo box on the same form.
I have a combo box with the row source as follows:

SELECT [Stores].[StoreName], [Stores].[Store#], [Stores].[cust_no] FROM
Stores WHERE ((([Stores].[cust_no])=[forms]![checkhead].[cust_no]));

This works fine on the first record, but on subsequent records when I have a
different cust_no the combo box still displays the stores from the previous
record.
What am I doing wrong?
Please help
 
Use the form's Current event to requery the second combo box:

Private Sub Form_Current()
Me.StoreComboBoxName.Requery
End Sub
 
Back
Top