How do I pass form parameteres to Queries? 1

[liamlaurent]

Hello all,

I would like to know if it is possible to pass the contents of a TextBox or the selected value in a ComboBox as a parameter to a query. If it is possible I would appreciate an example of the SQL syntax that does this.


Thanks
Liam

 

[randy700]

Something like....
If Field1 is numeric --
"SELECT Field1, Field2 FROM Table1 WHERE Field1 = " & Forms!FormName!ControlName
If Field1 is text --
"SELECT Field1, Field2 FROM Table1 WHERE Field1 = '" & Forms!FormName!ControlName & "'"

If Field1 is a date --
SELECT Field1, Field2 FROM Table1 WHERE Field1 = #" & Forms!FormName!ControlName & "#"


Randy

 

[liamlaurent]

Thanks a lot Randy.

Liam