[AccessD] Automating parameterized action queries.....

If you are not wanting to encode a particular form field because the query
is called from several forms, might I suggest that you create a new hidden
form that contains fields for all of the fields that are used as parameters.
Then the queries can access these fields.

You would need to set the fields on the form before the queries were
executed.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Sad Der
Sent: Tuesday, March 08, 2005 3:15 AM
To: Acces User Group
Subject: [AccessD] Automating parameterized action queries.....


Hi group,

my story of the queries continues. I need to run a set
of action queries. This works fine. 

Several queries have parameters. So that means the
user has to watch the screen for a parameter to
pop-up. Is it possible to add some parameter fields in
the form to fill the required parameters...WITHOUT
changing the query it self?

So I have a parameters in my query:
[Enter version:]
[Enter startdate:]

And I do not want to change these to: forms!frmReport!txtVersion
forms!frmReport!txtStartDate

TIA

Sander