I have following code (PREVIOUS POST WAS INCORRECT)
strOrder = "[Customer Name] = '" & [Forms]![Customer Add]![Customer Name] & "'" & " " & "AND" & " " & "[Customer Day] = '" & [Forms]![Customer Add]![DayPass] & "'"
[Forms]![Customer Add]![Customer Name] can have an apostrophe in it which causes a problem with syntax. I know this is probably really easy but my brain seems to not function this morning. What other delimeter can I use ie you use # for time ?
thanks
strOrder = "[Customer Name] = '" & [Forms]![Customer Add]![Customer Name] & "'" & " " & "AND" & " " & "[Customer Day] = '" & [Forms]![Customer Add]![DayPass] & "'"
[Forms]![Customer Add]![Customer Name] can have an apostrophe in it which causes a problem with syntax. I know this is probably really easy but my brain seems to not function this morning. What other delimeter can I use ie you use # for time ?
thanks
Last edited: