From Form to Report

  • Thread starter Thread starter REVBJONES
  • Start date Start date
R

REVBJONES

How do I open a report from a form, viewing the SAME
record I'm on in the from in the report

Bennie
 
Bennie,

Presumably the report is based on the same table/query as the form. If this
is the case, then all you need to do is call the report using the OpenReport
method, and supply a filter clause based on the current primary key value.

DoCmd.OpenReport "rptMyReport", acViewPreview, , "myPrimaryKey = " &
Me!MyFormsPrimaryKey

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Report and Forms 2
filtering a form based on a filter on an open form 2
Access Access Report Works on One Machine but not Another 3
Access 2010 Report Button 0
Can't create a report from my query in Access 1
Getting a Form recordset to a Report 4
Report distribution list 1
Date parameters for report 2

Back
Top