I come from a SQL Server background and am very familiar with store dprocedures and input parameteres.

Is there a way to use a similar method in Access. or example, passing parameters from a button on a form to a query, which can change depending on the input parameter? If so, how ?

Also, how much scope do you have in this for running SQL IF statements and such in the query? It seems that many Access queris can only have one statement at a time.

Qwert - Look at post 2 and maybe 13 in the thread linked below to get an idea of how to do some of this...

http://www.access-programmers.co.uk/forums/showthread.php?t=99777

Thanks.
So, you pretty much have to do it with VBA code? There's no way to pass parameters to queries in Access as you would with stored procdures in SQL server?

? ........

I would tend to think of vba code as a sort of tsql. So you could save a sql statement in a function and pass the param there and insert it into a sql statemnet you build on the fly in the function... Make sense? I'm not aware of a way of calling a stored query by name and passing it a param...

Are you looking for something like:

WHERE FieldName = Forms!FormName.ControlName

where each time the query is run it will look to that form control for the criteria?

More or less, yeah.

I guess then there you have it.