Main form combo box to find a subform record

[mergle]

I have a subform (Datasheet mode) on a main form (Single form mode). I normally just use the wizard to create a combo box to find a record on a form. However, I cant put this type of combo box on a datasheet subform, so I need to place it on my main form.

Question: How do I find a record on a datasheet subform, from a combo box placed on the main form? Once the combo box item is selected, I would need the found record to be highlighted/selected in the datasheet subform.

Make since?

 

[KenHigg]

One way is to build a query that uses that combo box as a parameter. Then when the combo box changes reset the subform recordource to this query.