Printing Forms current content

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
 
A

Allen Browne

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
 
Top