DoCmd.OpenReport Where Syntax error

[eRed]

This is about a Command Association with a button in a subform

COMMAND
DoCmd.OpenReport "AR", acViewPreview, , "[ar].[ltcfname]=" & Me.ltcfname.Value

When I run the code I get the following error:

Run-time error '3075':

Syntax error (missing operator) in query expression
'[ar].[ltcfname]=Arlington Heights'.

This filter works in the report
([ar].[ltcfname]="Arlington Heights")

the report's name is "AR"

can someone tell me what the heck I am doing wrong??

 

[John Big Booty]

If ltcfnamery is a text value it will need to be enclosed in double quotes try;

DoCmd.OpenReport "AR", acViewPreview, , "[ar].[ltcfname]=" & CHR(34) & Me.ltcfname.Value & Chr(34)

 

[John Big Booty]

....and Welcome to the forum

 

[eRed]

John Big Booty you are the man, thanks

 

[John Big Booty]

Glad to have been able to help