Print all records after choose by combobox

[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

[Don Leverton]

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

[David Deacon]

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!

[James Fortune]

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