I want to use a form to set parameters for a query.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am reasonably new to access and need to have a step by step procedure to
set this up
 
Smokey smith said:
I am reasonably new to access and need to have a step by step procedure to
set this up
Click to expand...

1. Build a form
2. Add a control (usually an unbound textbox)
3. Reference it in your query's criteria box like:

Forms!YourFormName!YourControlName

Substituting your names as appropriate.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
arvin i've been learning access for a few monthes, and you made a difficult
concept to me, soo simple.
 
You must log in or register to reply here.

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

Similar Threads

Query Parameter using multiple options 0
Browse button for access form 1
Parameter Value error in a Subform 0
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
Please help with instructions to make a bootable flash drive for linux 7
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Access #Error & Excel Pivot 0
Excel Excel VBA to run Access Parameter Query Error 3265 0

Back
Top