Search field from subform (1 Viewer)

[Okly]

I created a subform within a mainform. That means the mainform contains a subform. Now, I want to search a field called 'Product' from the subform. How can I write the expression in order to open the specific record that appears in the mainform? Please help. Thank you.

 

[gino]

look up requery in access help. very good explanation found there.

me.form.requery

you could use this in an afterupdate, onclick, etc.....