Form parameter Query

A

ad

I'm hoping someone can help me with this . I'm trying to get my query to use
a form to get the query parameters. When I run the query, it displays the
text "[Forms]![frmEE]![cboEE]" as a prompt rather than displaying the form
where the user can make a selection.

I'm using the build wizard to construct the following query:

SELECT Employees.*

FROM Employees

WHERE (((Employees.LastName)=[Forms]![frmEE]![cboEE]));
 
G

Guest

Your form MUST be open and the information entered before running the query.
You might put a command button on the form to run the query.
 
A

Anthony

Thanks Karl. You've been a big help. Have a good one.

KARL DEWEY said:
Your form MUST be open and the information entered before running the
query.
You might put a command button on the form to run the query.
--
KARL DEWEY
Build a little - Test a little


ad said:
I'm hoping someone can help me with this . I'm trying to get my query to
use
a form to get the query parameters. When I run the query, it displays the
text "[Forms]![frmEE]![cboEE]" as a prompt rather than displaying the
form
where the user can make a selection.

I'm using the build wizard to construct the following query:

SELECT Employees.*

FROM Employees

WHERE (((Employees.LastName)=[Forms]![frmEE]![cboEE]));
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top