Forms and Subforms.... expanding does not change the selected record (Datasheet view)

[Chris Underwood]

I have a form with a subform. On the subform there is a combo box
that I would like to filter based on a value in the main form.
If I select a record before I expand the subform everything works
great. If I expand the subform on a record that is not selected, the
data which I want to access on the parent form is from the wrong
record.

Is there anyway to force expansion of a subform, in datasheet view, to
select the record for that form. A better question would be: Is
there any way for the selection of a subform to select the record in
the main form that expanded the subform?


Chris Underwood

 

[Larry Linson]

That seems an unusual way to have them work... just the reverse of the
"normal" approach, which is to select the record on the main form, and show
records related to that mainform record in the subform. Perhaps if you'd
clarify what data you have, and what you are trying to accomplish, someone
could make a useful suggestion.

Larry Linson
Microsoft Access MVP