Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use the Form to input parameters of a Query
Message
From
13/07/2001 10:29:52
 
 
To
11/07/2001 13:01:47
General information
Forum:
Microsoft Office
Category:
Access
Miscellaneous
Thread ID:
00529246
Message ID:
00530239
Views:
16
>My Form's datasource is a Query, this Query need to input a parameter.
>Can I place a input text box on the Form header, use that input to assign to the Query parameter?
>-Jasper

I have used the following for specifying the parameters of a query, although I am not sure how it would work with the query being the form's datasource:

Set dbExtract = CurrentDb

Set qdfExtract = dbExtract.QueryDefs("qryAggregate")
qdfExtract.PARAMETERS("Parm1") = "Value"
qdfExtract.PARAMETERS("Order") = 29
etc..
Previous
Reply
Map
View

Click here to load this message in the networking platform