Datasheet view Programming

[Tom Olsen]

All,

I am trying to filter a field in a subform (with the subform set at
datasheet view). Field1 is a combo box I would like Field2 to be a combo box
but filtering only those records based on the Field1 selection.As you select
a record in datasheet view you have to use a requery in order for the Field2
to change to refresh the records. Unfortunately all of the reords above it
go blank also.

Help..

Thanks Tom