Hi guys,

I have a form in datasheet view and 2 combo boxes inside. What I try to do is that the combo box no. 2 must show only those records based on the value from combo box no. 1.
This work only for the first record in form, but for the second record, in combo box no. 2 I have the same options as for the combo box no. 2 from the first record even the combo box no. 1 from the second record is not equal with combo box no. 1 value from the first record.
I have in the row source for the combo box no. 2 something like this:
"select ....... from .... where someID = combo box no. 1 value"
and, of course, some code for afterupdate event of the combo box no. 1 to requery combo box no. 2

Any ideea, please?
Thx