How to reference forms for query criteria

[handlebars]

I am new to SQL server and am using an access adp to connect to a backend sql server. What i cannot find anywhere in the documentation is how to specify forms within SQL query (like using the builder in access).

Do you have to do it through code?

Any pointing in the right direction would be appreciated.

Andrew

 

[SQLSister]

Yes you have to do it through code. Basically you set the value of the form field to a variable, then use the variable as an input value for a stored procedure.

forum705 is where you shouold be able to find code examples


Questions about posting. See faq183-874