Requery combo box on a subform

[Brad]

I have a datasheet subform with 3 combo boxes. I have the first 2 combo boxes
cascade to the third. I set the after update on the first 2 combos to requery
the third with the following code:

Me.Dirty = False
Me.cboIssue.Requery

When the next record is selected the requery erases the value in the first
record. Any ideas on how to fix this where the requery only requeries the
active record?

 

[Maurice]

I understand your wish for this to work only this functionality won't work in
a datasheet mode...

 

[Brad]

Would this work if i did a tabular form instead of datasheet?

 

[Maurice]

You mean like a continous form in tabular layout? Nope.. only single form
will do that for you.