how to make a criteria in a query in ms access web

mana

Registered User.
Local time
Today, 13:20
Joined
Nov 4, 2014
Messages
265
hello,

i want to make a criteria in my query in a column as belowL:

<[Forms]![Projects]![Real_date]

projects is the name of my form and real_date is the name of my field in my form. but i have this error message

you have attempted to use an undeclared parameter.
what should i do to have this criteria in my query
can you help me please?
thank you
 
Hey, are you using A Web App or a 2010 Web Database?

If it's a Web App then it sounds like you need to open the query designer and click the parameters button at the top of the page. You'll need to declare the parameter here (make sure you use the correct data type or you might get a conversion error).

Once you've declared the param there, save the query and head to your form. You'll need to pass the parameter to the query and how you do that will depend on how you want to run the query. If you want to click a button and have a popup display the results then you need to create you button and have that button create a popup with the On Click event. Create a new form which uses you query as a record source and have the button open this new form as a popup On Click. This event should ask you for a parameter - use the expression builder to feed the contents of you real_date control into the parameter...

that shoud do it I think, unless you're using Web Databases... in which case I can't help :) sorry!

N
 

Users who are viewing this thread

Back
Top Bottom