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 = "rptGSTCollecte d"
strWhere = "[PaidMonth]= #" & Me!fsubGSTRecie ved![PaidDate] & "#"
DoCmd.OpenRepor t strDocName, acPreview, , strWhere

[Don Leverton]

Re: Print all records after choose by combobox

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+Leverton+group:comp.databases.ms-access&start=10&hl=en&lr=&ie=UTF-8&oe=UTF-8&scoring=d&selm=VDvfc.25860%24mn3.21189%40clgrps13&rnum=12

Don



"DD" <david.deacon@b igpond.com.au> wrote in message
news:1412655e.0 404240120.adfef b6@posting.goog le.com...[color=blue]
> 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 = "rptGSTCollecte d"
> strWhere = "[PaidMonth]= #" & Me!fsubGSTRecie ved![PaidDate] & "#"
> DoCmd.OpenRepor t strDocName, acPreview, , strWhere[/color]

[David Deacon]

Re: Print all records after choose by combobox

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]

Re: Print all records after choose by combobox

david.deacon@bi gpond.com.au (DD) wrote in message news:<1412655e. 0404240120.adfe fb6@posting.goo gle.com>...[color=blue]
> 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 = "rptGSTCollecte d"
> strWhere = "[PaidMonth]= #" & Me!fsubGSTRecie ved![PaidDate] & "#"
> DoCmd.OpenRepor t strDocName, acPreview, , strWhere[/color]

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

fsubGSTReceived .Form.[PaidDate]

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

James A. Fortune