search and go to record

[ashley]

I have a main form and a subform (continuous form) which
data is linked. I have a combo box that searches for the
records that are in the subform and only displays the
records that the main form is related to the subform. How
would I make it the subform go to the record that I was
searching for in the main form since the subform is a
continuous form?

Thanks.

 

[Jeff Boyce]

Ashley

I'm a bit confused. Usually, a main form/subform construction is used to
allow selection of a particular record on the main form, then display all
the related (one-to-many) records in the subform. I don't understand why
(as in how you are using this) you need to pick a subform record in order to
go to a main form record. The only records showing in the subform should
be, by definition, related to the main form record.

What am I missing?

 

[ashley]

Jeff,

The combo box on the main form is suppose to search for
records in the subform and only show corresponding records
in the main form. Since the subform does show multiple
records for the main form, I want it to go to the record
that it was searching, so that the user does not have to
scroll in the subform to look for the item it was
searching for.