Query works, but same where condition does not with OpenForm

[chronister]

Hello all... I am creating a search function to search a name. The DB stores it as [First Name] , [Last Name].... This query works

SELECT *
FROM tblVolunteers
WHERE ((([First Name] & " " & [Last Name]) Like "*bob j*"));

It will show me records for Bob Johnson, Bob James and Bob Jones....



am trying to duplicate this with a DoCmd.OpenForm statement... can anyone tell me what I am doing wrong? Replacing the static name with a field variable.

Dim whereClause As String
whereClause = "[First Name]" & " " & "[Last Name] Like " '*" & volunteerName & "'*""
DoCmd.OpenForm "Volunteers", acNormal, , whereClause, , , False

[pbaldy]

Try



whereClause = "[First Name] & ' ' & [Last Name] Like '*" & volunteerName & "*'"

[chronister]

Forgot to mention... getting Syntax Error (Missing Operator)..... thanks for the help in advance folks

[chronister]

U the man.... that fixed it.....

Thanks a bunch. I am still fairly new to Access in depth. I am still trying to pick up on the syntax and such for creating spaces in fields and concatenating things. I will study that and see exactly what it is that I missed before. thank you sir

[pbaldy]

Happy to help!