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

OpenReport option

P: n/a
Hi,

Thanx to all the help I have received from this group, I can now
successfully print a form that has been split into two reports at the
one time. However, I am suffering from severe brain fade in regard to
printing only the current record the form is showing.

So, how can I make the DoCmd.OpenReport ensure that only the current
record is printed, not each and every record in the db?

Stinky Pete ;-)

Aug 28 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Use the WhereCondition of OpenReport.

Details in:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Stinky Pete" <Pe**********@symbionhealth.comwrote in message
news:11*********************@p79g2000cwp.googlegro ups.com...
>
Thanx to all the help I have received from this group, I can now
successfully print a form that has been split into two reports at the
one time. However, I am suffering from severe brain fade in regard to
printing only the current record the form is showing.

So, how can I make the DoCmd.OpenReport ensure that only the current
record is printed, not each and every record in the db?

Stinky Pete ;-)

Aug 28 '06 #2

P: n/a
Hi Allen,

Thanx once again for your guidance and direction. It's working a treat
;-)

Regards,

Stinky Pete ;-)

Allen Browne wrote:
Use the WhereCondition of OpenReport.

Details in:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Stinky Pete" <Pe**********@symbionhealth.comwrote in message
news:11*********************@p79g2000cwp.googlegro ups.com...

Thanx to all the help I have received from this group, I can now
successfully print a form that has been split into two reports at the
one time. However, I am suffering from severe brain fade in regard to
printing only the current record the form is showing.

So, how can I make the DoCmd.OpenReport ensure that only the current
record is printed, not each and every record in the db?

Stinky Pete ;-)
Aug 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.