>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only