Fran, it sounds like you have the parameter set up twice. Is the query perhaps pulling on another query that also asks for the same parameter?
You might want to try using a FORM FIELD to provide the parameter. It's a little more complex, but it works much better. Here is a tutorial that explains how:
You can literally set up a small form with ONE field in it (the parameter) and then make a command button to launch the query, which gets the parameter from your form. Neat, huh?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 104.
