parameter of a query

[giannis]

I have make a query that ask a parameter (for criteria).
This query opens a form with criteria this parameter.
I need a label in this form that says the criteria (=parameter).
How can store the parameter of query in this label ?

 

[JohnFol]

Put the parameter in the query as a field. For example, try his in NWind

SELECT Employees.EmployeeID, [EnterEmployeeID] AS EnteredParameter,
Employees.LastName, Employees.FirstName
FROM Employees
WHERE ((([EnterEmployeeID])=[employeeid]));

You now have a field called "EnteredParameter" available to display on the
form

 

[giannis]

Thank you !!!
I didnt know the word "AS" in SQL .

Put the parameter in the query as a field. For example, try his in NWind

SELECT Employees.EmployeeID, [EnterEmployeeID] AS EnteredParameter,
Employees.LastName, Employees.FirstName
FROM Employees
WHERE ((([EnterEmployeeID])=[employeeid]));

You now have a field called "EnteredParameter" available to display on the
form

I have make a query that ask a parameter (for criteria).
This query opens a form with criteria this parameter.
I need a label in this form that says the criteria (=parameter).
How can store the parameter of query in this label ?