Using Variables In Where Queries

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????

hows about this??

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

Thanks alot Jimbob, that worked great.