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

Print all records after choose by combobox

P: n/a
DD
I have frmMain and fsub
you choose a month from the ChooseMonth combo and all the records for
that month are nopw visible in the fsub
I know print with the following Where and only recieve the record that
is selected in the fsub when i want all the records
Can some one help correct my code
dd
strDocName = "rptGSTCollected"
strWhere = "[PaidMonth]= #" & Me!fsubGSTRecieved![PaidDate] & "#"
DoCmd.OpenReport strDocName, acPreview, , strWhere
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi David,

I assume that didn't like my suggestion that I made in response to:
"Print from date selection" that you posted on 04/14/2004?

It allows you to print JUST the records that you specify, OR you can choose
"(All)" from the combo-box and ALL of the records get printed.

Here's the link again if you cant find it..
http://groups.google.ca/groups?q=Don...grps13&rnum=12

Don

"DD" <da**********@bigpond.com.au> wrote in message
news:14*************************@posting.google.co m...
I have frmMain and fsub
you choose a month from the ChooseMonth combo and all the records for
that month are nopw visible in the fsub
I know print with the following Where and only recieve the record that
is selected in the fsub when i want all the records
Can some one help correct my code
dd
strDocName = "rptGSTCollected"
strWhere = "[PaidMonth]= #" & Me!fsubGSTRecieved![PaidDate] & "#"
DoCmd.OpenReport strDocName, acPreview, , strWhere

Nov 12 '05 #2

P: n/a
Hi Don
I have tried to adapt the code you sent and i am having trouble.
I am still learning about code and your code is a little confusing for
me
I will keep trying but i am having difficulty
DD

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

P: n/a
da**********@bigpond.com.au (DD) wrote in message news:<14*************************@posting.google.c om>...
I have frmMain and fsub
you choose a month from the ChooseMonth combo and all the records for
that month are nopw visible in the fsub
I know print with the following Where and only recieve the record that
is selected in the fsub when i want all the records
Can some one help correct my code
dd
strDocName = "rptGSTCollected"
strWhere = "[PaidMonth]= #" & Me!fsubGSTRecieved![PaidDate] & "#"
DoCmd.OpenReport strDocName, acPreview, , strWhere


Instead of Me!fsubGSTRecieved![PaidDate], I would use something like:

fsubGSTReceived.Form.[PaidDate]

if the Name of the Subform control on frmMain is fsubGSTReceived.

James A. Fortune
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.