I followed your instruction to build a search form from this video, https://www.youtube.com/watch?v=imEOGui5eic.

Everything worked fine until I bound the form to the Query.  The query/search worked fine, but what stopped working is the "open customer" button and the double click event to open to specific customer (also learned from your previous videos).

The error message for the open customer button is type mismatch, and for the double click event is "Run-time error 2424: the expression you entered has a field, control, or property name that Microsoft Access can't find."

I checked the VBA code, and it didn't strike me anything that would mess up with the function.  The VBA code is as below:

If IsNull(ReferenceID) Then Exit Sub
    DoCmd.OpenForm "ReferenceEntryF", , , "ReferenceID=" & ReferenceID

ReferenceID is the autonumbered field name I use to match records, FYI.

Is this error message normal, meaning that are there other steps I need to carry out after changing the binding my form to the the Query created in the record source.

Thank you.