Using Variables In Where Queries

[whittam]

I am trying to write an sql where query which will retrieve a group of records based upon a variable which was assigned earlier in the program.

The variable is global, but everytime I run the program I get missing parameters.

The following is the Sql I am using

"Select * From [OInspect] Where AgentID = AgentNo"
AgentId is a field in the table AgentNo is the Global variable
Has anyone got any suggestions????

[Jimbob]

hows about this??

"Select * From [OInspect] Where AgentID = " & AgentNo

[whittam]

Thanks alot Jimbob, that worked great.