print record current displaying

  • Thread starter Thread starter rahmad
  • Start date Start date
R

rahmad

Hi All,
Would somebody help to give a command button code which can
print the current displayed record or based on a filtered record
 
Hi rahmad,

Build a report that shows the fields as you would like them to be printed,
then set the query for that report to display all records.

When you open your report, pass a where clause, like this:

docmd.OpenReport "REPORTNAME", acViewPreview, , "[ID]=" &
forms!FORMNAME.IDFIELD, acWindowNormal

Hope that helps.

Damian.
 
Back
Top