Syntax for referencing controls from the query pane

[livvie]

This is what I am trying to do in Access 2003 .adp
SELECT rec_batch, rec_jobid
FROM tblctmist
WHERE (rec_batch <> ' ') AND rec_jobid = [Forms] ! [frmWorksOrderComplete].[Form] ! [fsubWOrderHead] ! [txtjobid]
ORDER BY rec_batch DESC

but I get an invalid sql error

 

[Mile-O]

Why are you putting spaces between the form properties?

ie.

] ! [

it should be ]![

 

[livvie]

Why are you putting spaces between the form properties?

ie.

] ! [

it should be ]![

That happens when I try to run it Access reformats it that way.