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.

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

me.form.requery

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