="[Mem_ID] = " & Str(Nz(Screen.ActiveControl,0))

[Mohammadsharif]

how can we use ="[Mem_ID] = " & Str(Nz(Screen.ActiveControl,0)) in search for a record of a macro

[CJ_London]

depends on how your form is working - if the code to open the query is a button, the screen.activecontrol will be the button. You might want to consider using screen.previouscontrol instead.

[ranman256]

Docmd.openform "frmDetail",,"[Mem_ID] = " & Me!TxtMemID