Form parameter Query

  • Thread starter Thread starter ad
  • Start date Start date
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]));
 
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.
 
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]));
Click to expand...
Click to expand...
 
Back
Top