dmcafee at pacbell.net
dmcafee at pacbell.net
Mon Jan 3 13:54:37 CST 2005
Just getting into this thread (so I might have missed something if was already mentioned)... I usually have a form for this purpose with two fields (Start Date and End Date) and a command button. When the button is pressed this little pop up form is hidden and the report is opened. the reports (saved) queries and (saved) sub queries look to the hidden form for the start and end dates. The OnClose event of the report closes the date form so that it can be called again. HTH David McAfee -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bobby Heid Sent: Monday, January 03, 2005 9:03 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Weird query question Drew, But the how do I pass parameters to the sub query. <snip>