print record current displaying

[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

 

[Damian S]

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.