By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,365 Members | 3,180 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,365 IT Pros & Developers. It's quick & easy.

How to use form to print report

P: n/a
May anyone can teach me how to use form to set report parameter, my
design in FORM is :

From [date] to [date], [ALL]
Customer ID from [CusID} to [CusID], [ALL]
Index on [ ]

[To Printer] [Preview]
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Apple wrote:
May anyone can teach me how to use form to set report parameter, my
design in FORM is :

From [date] to [date], [ALL]
Customer ID from [CusID} to [CusID], [ALL]
Index on [ ]

[To Printer] [Preview]


Create a query with the fields you want to see in the report. In your
query you can use parameters to filter on the date. In the date field
enter this parameter.

Between [Enter start date] And [Enter End Date]

You could then place code behind a command button to call the query.
I would use the wizard to create the button as this puts in error
checking code as well.

David

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.