Cascading Combo Boxes w/ SQL in a PRoject

[pltaylor3]

For some reason I cannot get this code to create my cascading combo
box.

SELECT EngineNumber FROM dbo.Engine
Where(((Program)=[forms]![Selection]![prgrm]))

This is pulling information from a SQL database that the form is linked
to and it gives me the error "Incorrect Syntax near '!'" the names of
the access value are correct and the query works when i stick a value
for prgrm in place of the "[forms]![Selection]![prgrm]"
any help would be greatly appreciated.
thanks

 

[pltaylor3]

That leads to an empty combo box. I am open to suggestions. I believe
it is passing the value & [forms]![Selection]![prgrm] & instead of what
that value should represent (i.e. the value in the text box prgrm).

Try this:

SELECT EngineNumber FROM dbo.Engine
Where(((Program)='" & [forms]![Selection]![prgrm] & "'"))

For some reason I cannot get this code to create my cascading combo
box.

SELECT EngineNumber FROM dbo.Engine
Where(((Program)=[forms]![Selection]![prgrm]))

This is pulling information from a SQL database that the form is linked
to and it gives me the error "Incorrect Syntax near '!'" the names of
the access value are correct and the query works when i stick a value
for prgrm in place of the "[forms]![Selection]![prgrm]"
any help would be greatly appreciated.
thanks