Combo boxes on datasheets

[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

 

[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