auto-assigning parameter to query

  • Thread starter DannyAM via AccessMonster.com
  • 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
 
T

Ted Allen

Hi Dan,

Yes, you can replace the parameter prompt with:

Forms![YourFormName]![YourFieldName]

HTH, Ted Allen
 
Top