How to display value in report

[confuse]

hi to all!! Please do help me..

I have a problem in displaying data from report. I have a form with group options checkbox which the user can choose which report he wants to display either Product Comparison Cost,Product Purchases by Supplier, Product Sales per day, but before that the user must enter the beginning date and ending date for the report. I have also form which ask for the beginning and ending date.

My problem is after i fill out the necessary dates there is no report displayed..Please do help with the codes.


Thankss...

Your help is greatly appreciated....

 

[stopher]

What code have you got so far?
Chris

 

[Luddite Lad]

Firstly you will need to create a query that collects all the data, you need in your report, based on the information you have put on your form.

Once you have created that query, it should be a simple matter to create a report based on the query.

 

[confuse]

What code have you got so far?
Chris

My code is like this:

Private Sub Frame0_AfterUpdate()
Select Case Frame0.Value
Case 1
DoCmd.OpenForm "Report Date Range", acNormal

Case 2
DoCmd.OpenForm "Report Date Range", acNormal


Case 3
DoCmd.OpenForm "Report Date Range", acNormal

Case 4
DoCmd.OpenForm "Report Date Range", acNormal


Case 5
DoCmd.OpenReport "Branch Sales Report", acPreview

Case 6
DoCmd.OpenReport "Product Selling & Buying Price Report", acPreview

Case 7
DoCmd.OpenReport "Product Sales Report in a Day", acPreview
End Select

End Sub

Thats my problem because i dont really know the visual basic codign part..

please do help...

thanks..