auto-assigning parameter to query

  • Thread starter Thread starter DannyAM via AccessMonster.com
  • Start date Start date
D

DannyAM via AccessMonster.com

I have a command button on a form which is set to preview a parameter query
(displayed as a report). Is there any way that i can automatically assign a
field from the form to act as the paramater value? Any help would be
greatly appreciated.
Thanks
Dan
 
Hi Dan,

Yes, you can replace the parameter prompt with:

Forms![YourFormName]![YourFieldName]

HTH, Ted Allen
 
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

Parameter Query Won't Run 0
Passing parameters via MS Query to Access 1
optional parameter for query 2
Parameter Query No Results - Needs to Auto Create Record 4
Why is my copied Query is keeping parameters? 4
Parameter Query Problem 2
Access Access Report Works on One Machine but not Another 3
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2

Back
Top