parameter querie

M

matthda

After creating parameter queries I will be promted for the Information twice.
What am I doing wrong?
 
J

John W. Vinson

After creating parameter queries I will be promted for the Information twice.
What am I doing wrong?

I don't know; what are you doing? We can't see your query.

What you might want to consider (especially if you're using the parameters in
a query and a subquery, or in a Report, etc.) is create a little unbound Form
named frmCrit with textboxes for the paramters. Rather than a prompt like

[Enter start date:]

use

[Forms]![frmCrit]![txtStartDate]

This will also let you put a command button on frmCrit to open the Report or
Form on which the query is based, so the user doesn't need to see the query
datasheet at all.
 
J

Jerry Whittle

Please show us the SQL statement for the query. While in query design view,
go to SQL view. Copy the sql statement and post it here.
 
Top