parameter query not working ...

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

I have a form that is based on a parameter query. I
launch the query using a button on another form. The
criteria set in the parameter query is "[Forms]!
[FormProcurementSearch]![PCStoreReference]".

When I launch the query, it prompts for the
[PCStoreReference] and works fine. However, when I launch
the form itself or use the button on the
FormProcurementSearch form, the parameter is ignored.

I have used parameter queries quite often and can't seem
to figure out why this is happeneing. Any ideas?

Thank you so much,
Grace
 
Hi,


If you use a parameter like FORMS!FormName!ControlName, you have to
use DoCmd, or inside a Record Source property (dot-mdb application), or as
argument within Dxxx domain functions, or similar context, if you wish to
have it AUTOMATICALLY resolved for you. If you use CurrentDb to execute the
query with such a parameter, you will have a solve the parameter (through
the parameters collection). See
http://www.mvps.org/access/queries/qry0013.htm



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top