Using Search Form - Problem

[Vidar13]

I'm trying to use FormX to lookup possible values in FormY's recordset. Form X uses a subform with a "Like" parameter query to bring up all the possible records and then allow user to select value they want and have FormY go to that record.

To further explain, FormY contains a "Name" field, and I want to allow the user to lookup the name using any search text of the name (partial name search), and then allow them to select the exact name they are after. "ContactID" is the unique key field and "Name" is the field I wish to search on.

 

[Vidar13]

One final note: I have succeeded in getting everything to work EXCEPT, I can't use the FindRecord method to find the selected record in the "other form" (FormY). Also, using the DoCmd.OpenForm method with a "Where" parameter won't work, since it filters the form for that one value and won't show the rest of the recordset. I simply want FormY to MOVE to that record