Parameterized Queries in Access 2010

[Raptor_45]

Hi, I have a database running on SQL Server and I have created some forms in Access 2003. Some of the forms call stored procedures and functions which prompt you for the required parameters. Access 2003 automatically pops up a box that asks me for the parameters then either returns the results or inserts the data. Access 2010 won't prompt me for the parameters, it just gives me an error saying missing required parameter or something. I've heard people say I need to create a pass through query. I tried this but couldn't get anything to work without hard coding the parameters.


Why does Access 2003 prompt for parameters and Access 2010 doesn't? Do I need to rewrite these procedures and functions? Thanks,



Jess

[NTC]

well try this: in query design view - with your cursor in white space in the upper half of the view; right click and select 'Parameter': in the box that opens - enter the field name of the column that has the parameter prompt and enter its data type (text, integer, date, etc) - save and try...... just a guess

if that doesn't work you are going to have to experiment a little....