Help with Openform with DblClick selected record

[scottb]

Hi everyone,
Hans, you helped me with a version of this a while back. It’s a search form that allows the user to double click and open another form (DEMOGRAPHIC) with the selected record. I copied the original that is working and tried to apply it to this instance and I cannot get the double click/open form event to work. Not sure what I missed. Any help would be appreciated. Thank you. -Scott

[HansV]

You have this line:

Code: Select all

        DoCmd.OpenForm "frmCaseLogSearchNew", , , "SER_NUM" & Me.QuickSearch

In the first place, you want to open the form DEMOGRAPHIC, not frmCaseLogSearchNew for that is the form from which you call the code.
In the second place, the OpenArgs argument must be of the form SER_NUM=...

So:

Code: Select all

        DoCmd.OpenForm "DEMOGRAPHIC", , , "SER_NUM=" & Me.QuickSearch

[scottb]

Thank you Hans.