combo boxes and finding records

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

Guest

I have a query with 5 fields Year, YearID, ManufacturerID,
ManufacturerName, and AMount.
I would like to be able to update the manufacturerName
combobox and then the year combo box and find the right
information in the amount field. can I filter the second
combo box based on the first combo box and then find the
right amount from those 2 combo boxes?
 
Bob,
Assuming that the two combos boxes have 2 queries as row
sources, after you make a selection in the 1st combo box,
change the query of the second. Something like:
strSQL="Select ... From ... Where ID = " & Me.cbo1.Column
(0)
Me.cbo2.RowSource = strSQL
Me.cbo2.Requery

Geof
 
Back
Top