| re: Print selected records from combo
It is just a matter of extracting the Year from the date and constructing
the appropriate WHERE clause for the Report's RecordSource. It does require
some VBA.
The Year function extracts the year from a date, for example, try this from
the immediate Window to test.
? Year(#03/15/2002#)
If the records are to be selected from a date field, then you'll have to
extract the Year and put the criteria on that calculated field.
Larry Linson
Microsoft Access MVP
"DD" <david.deacon@bigpond.com.au> wrote in message
news:1412655e.0404161554.17cadc2d@posting.google.c om...[color=blue]
> I have a mainForm with a subForm
> On the main form i have a combo with March 04, April 04 etc, you
> select a date and the subform shows all records for the selected date.
> I can print a selected record, how ever i want to print all the
> records for the month selected.
> Can anyone advise please
> Regards
> DD[/color]
| 
