How Do I Use The Filter Property On An Open Query?

[smithph]

Hi, All,
I have a form that uses a query to read records from a table on a one at a time basis. I can click Next Record, Previous Record buttons to navigate through the table. There is a subform on this form, using a different query, that looks at some of the records that the main form looks at depending on a flag in one of the table's fields. There might be six entries in the subform display. I want to click in one of the fields in the subform and make the main form move to that particular record. The record will be unique. I can obtain the text from the field in the subform that I want, but how do I make the main form query move to the desired record?

 

[scking]

Me.Parent.Filter = "Put your filter criteria here"
Me.Parent.FilterOn = True


Steve King Growth follows a healthy professional curiosity

 

[smithph]

Thanks for that but I can't see how to tell the filter which field in the query to filter on. I have the contents of the field for the record I want. Tried all sorts of stuff to get the filter to look at the right field but no luck.