Unexplainable Syntax Error

[Dustin]

In access 2003 why would this produce a syntax error of:
(missing operator) Device ID=Motor 1
DoCmd.OpenReport "YourReport", acPreview, , "YourPrimaryKey = " &
Me![YourPrimaryKeyControl]

 

[Ken Snell [MVP]]

Post the whole code, please. My first glance would say that the

Device ID = Motor 1

is the problem, but I hate to jump to conclusions....

 

[Dustin]

The Code Entered is:

Private Sub Command75_Click()
DoCmd.OpenReport "Cathodic Data Sheet", acPreview, , "Electrical ID &"
Me.[Combo78]

End Sub

Combo 78 is where motor 1 returns from a lookup field Electrical ID is my
primary key and the syntax error I get says that I am missing an operator in
the expression that is returned which is Electrical ID=Motor 1
--
Dustin

Post the whole code, please. My first glance would say that the

Device ID = Motor 1

is the problem, but I hate to jump to conclusions....

--

Ken Snell
<MS ACCESS MVP>

In access 2003 why would this produce a syntax error of:
(missing operator) Device ID=Motor 1
DoCmd.OpenReport "YourReport", acPreview, , "YourPrimaryKey = " &
Me![YourPrimaryKeyControl]

 

[Van T. Dinh]

Try:

DoCmd.OpenReport "Cathodic Data Sheet", acPreview, , _
"[Electrical ID] = """ & Me.[Combo78] & """"

Don't use space or other special characters in names. If you do, make sure
you have the square brackets to delimit the actual names!

 

[Dustin]

Thank You Very Much that has been bugging me all day and it's the last thing
I have to get working in this database. Thank You Thank you Thank You
--
Dustin

Try:

DoCmd.OpenReport "Cathodic Data Sheet", acPreview, , _
"[Electrical ID] = """ & Me.[Combo78] & """"

Don't use space or other special characters in names. If you do, make sure
you have the square brackets to delimit the actual names!
--
HTH
Van T. Dinh
MVP (Access)

The Code Entered is:

Private Sub Command75_Click()
DoCmd.OpenReport "Cathodic Data Sheet", acPreview, , "Electrical ID &"
Me.[Combo78]

End Sub

Combo 78 is where motor 1 returns from a lookup field Electrical ID is my
primary key and the syntax error I get says that I am missing an operator
in
the expression that is returned which is Electrical ID=Motor 1