Combo boxes on datasheets

  • Thread starter Thread starter Thomas Kroljic
  • Start date Start date
T

Thomas Kroljic

I have a data sheet form that has two combo boxes per record.
I would like the user to select a manufacture from combo box 1 after which
Combo box 2 will list only items the manufacture from combo box 1 makes.

Originally, I added vba code to the "after update" event for combo box 1 as
follows:
me.[combo box 2].requery.

This works but it changes all of the combo boxes for combo box 2 in the data
sheet form instead of just the current row.

Any suggestion as to how I would fix this?

Thank you,
Thomas Kroljic
 
More info on my combo box.

As part of the query for combo box 2, I have a field that links to the value
in combo box 1. Under criteria I have the following: forms!formname!field

Thank you,
Thomas Kroljic
 
Back
Top