Cascading combo boxes in datasheet view

[Hjava]

I have a problem with a combo box in a datasheet view. I want the combo box to pull information from a query, but the query is filtered by two of the fields within the form.



This works fine for the first record, then all other records in the sheet use the same data even though they should be changing.

I have tried using a AfterUpdate to get the combo boxes to requery to no effect.

Please help you access geniuses out there.

[llkhoutx]

The datasheet como boxes do not have the correct "row source." They should tumble with each new record and do not need to be requeried.