Hi All,
I am in desperate need of some help.
I am fairly new to creating access databases, I have a Search page that filters the results in a Subform below, and from this form I would like to double click on the code and have it open the details of that particular Code.
I have added the below code on the double click event:
Private Sub Internal_Unit_Code_DblClick(Cancel As Integer)
DoCmd.OpenForm "PrecedentDetails", , , "Internal Unit Code = " & Me.Internal_Unit_Code
End Sub
However when i double click on the relevant Code to open it is coming up with he following:
Run-time error '3075':
Syntax error (missing operator) in query expression 'Internal Unit Code = COMP1004'.
Could someone please help.
Thank you
I am in desperate need of some help.
I am fairly new to creating access databases, I have a Search page that filters the results in a Subform below, and from this form I would like to double click on the code and have it open the details of that particular Code.
I have added the below code on the double click event:
Private Sub Internal_Unit_Code_DblClick(Cancel As Integer)
DoCmd.OpenForm "PrecedentDetails", , , "Internal Unit Code = " & Me.Internal_Unit_Code
End Sub
However when i double click on the relevant Code to open it is coming up with he following:
Run-time error '3075':
Syntax error (missing operator) in query expression 'Internal Unit Code = COMP1004'.
Could someone please help.
Thank you