VBA, Passing parameter to query from multiple forms

Passing parameter to query from multiple forms

Author	Message
Spencer Tabber #1 / 3	Passing parameter to query from multiple forms Is there a way to use the same query for a report and a form given that the query has parameters. Basically what I want to do is pass the parameter from a calendar object in Access. I don't want an action box to pop up asking me for the date. Right now I have hardcoded in the Query where the parameter should reference its data from like [forms]![frmForm]![txtquerydate]. So the query only works properly if you access it from the form and not the report. Is there a better way to do this so that the query can be reused and passed a generic parameter from any form without explicitly specifing the Form name and such. Thanks
Fri, 18 May 2001 03:00:00 GMT

Spencer Tabber #2 / 3	Passing parameter to query from multiple forms Is there a way to use the same query for a report and a form given that the query has parameters. Basically what I want to do is pass the parameter from a calendar object in Access. I don't want an action box to pop up asking me for the date. Right now I have hardcoded in the Query where the parameter should reference its data from like [forms]![frmForm]![txtquerydate]. So the query only works properly if you access it from the form and not the report. Is there a better way to do this so that the query can be reused and passed a generic parameter from any form without explicitly specifing the Form name and such. Thanks
Fri, 18 May 2001 03:00:00 GMT

Manish Jh #3 / 3	Passing parameter to query from multiple forms I would suggest making the recordsource of the report as a temporary table which is created just before opening the report by running a make table query off the parameter query you have in question... HTH -- Manish Jha Author of the Access Addin for developers Data Flow Manager Visit http://pages.prodigy.net/manishj/psdfm.htm Quote: > Is there a way to use the same query for a report and a form given that the > query has parameters. Basically what I want to do is pass the parameter > from a calendar object in Access. I don't want an action box to pop up > asking me for the date. Right now I have hardcoded in the Query where the > parameter should reference its data from like > [forms]![frmForm]![txtquerydate]. So the query only works properly if you > access it from the form and not the report. Is there a better way to do > this so that the query can be reused and passed a generic parameter from any > form without explicitly specifing the Form name and such. Thanks
Tue, 22 May 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]