Report from a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I have a report print only the most current record of
a subform that was generated by a query?
 
Yes, you certainly can by using the DoCmd.OpenReport method
and putting in the reference to the subform record ID in the
WHERE clause. You will probably need to supply some details
such as the field name of your ID field, report name, what
you mean by 'most current', etc... if you want detailed help

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
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

Printing a single record from a tab control subform 10
Access Access Report Works on One Machine but not Another 3
extra record in subform 1
Display most recent comment in report 14
Access Main form/Subform Navigation 0
Pass Subform filter to subform in report 0
Subform help for a case management database 7
Form - Subforms Question (please, help) 3

Back
Top