pass value to parameter

[Bullsandbears123]

I need to set a parameter value and open a report in ACCESS with VB.
I have a SQL statement

SELECT field1 FROM table1 WHERE field1=[input]

I need to pass a value into [input] when I open the query to run a report. Any idea of how to do this. Should I be using dynamic SQL, something like
SELECT field1 FROM table1 WHERE field1=?
or
SELECT field1 FROM table1 WHERE field1=@input

I never used dynamic SQL so I do not know how to reference the parameter any idea will help a bunch.

THANKS

PS. I know query1.[input]=5 does not work.

 

[rasx]

Are you writing VBA in Access or are your calling an Access MDB file via ADO from a VB 6.x application?


Bryan Wilhite
info@songhaysystem.com

http://www.songhaysystem.com

 

[Bullsandbears123]

I'm writing in VBA in ACCESS

 

[Bullsandbears123]

I figured it out THANK YOU!