HELP!!!!!!!!!!

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

All I need it to do is gather all the september dates from
the query and put them on to the september report. Is
there a way to do the on the reports filter?
 
Andy said:
All I need it to do is gather all the september dates from
the query and put them on to the september report. Is
there a way to do the on the reports filter?
Click to expand...


Possibly, but I think there's a cleaner approach. You
should have a form with a combo box where users can select
the month and a button to print the report. The button
wizard will generate most of the code for you so all you
have to do is modify the code to look more like:

Dim strDoc As String
Dim strWhere As String

strDoc = "nameof report"
strWhere = "Month([datefield]) = " & Me.thecombobox
DoCmd.OpenReport ,acViewPreview, , strWhere

the above presumes that the combobox's bound column is the
number of the month.
 
Back
Top