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
 
Back
Top