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

Print selected records from combo

P: n/a
DD
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <da**********@bigpond.com.au> wrote in message
news:14**************************@posting.google.c om...
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.