Printing Forms current content

  • Thread starter Thread starter johnb
  • Start date Start date
J

johnb

Hi all,
What is the best way to requery a form from within that
form?
In A2002 I have form to collect info on product faults.
Having entered the data I have cmdbutton to fire a report.
The report is based on a query which gets its data from
the form, only its does not pick up the current record.

TIA johnb
 
The current record will need to be saved before the report can pick it up,
so try something along the lines of:
If Me.Dirty Then
Me.Dirty = False
End If
DoCmd.OpenReport ...

You can use the WhereCondition of the OpenReport action if you wish to print
only the record in the form. Example in article:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html
 

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

Bold 1 or many fields in a report 3
Access Access Report Works on One Machine but not Another 3
Employee's Form Problem 1
Print current form record 2
Printing current record of a form 2
Requery form 2
Delete Record #Name? 3
Print a report from a form based on a query 4

Back
Top