Report from a subform

G

Guest

Can I have a report print only the most current record of
a subform that was generated by a query?
 
G

Gary Miller

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
________________________
 

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

Populate main form from subform record 0
200KB versus 35MB 0
DLookup in Continuous form 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can I save a sql statement generated by a search form? 1
Printing a single record from a tab control subform 10
Program buttons to create a word document 0
Report Group Footer DLookUp 0

Top