Going to a specific Record

[tani1978]

Hello Friends,
I have a search Form and I want that by double clicking on a record, another form candidates_form opens where the record is saved.
I have created a macro and given it the condition
"[Forms]![Search]![First]=[Forms]![candidates_form]![First]".
But this is not working.
Any advise friends.
Thanks in advance

 

[PHV]

Have a look at the 4th argument of the DoCmd.OpenForm method.
Tip: stay away from macros and use event procedures.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886