Reports not printing data, it prints controls only.

[talktime]

Hi All
i m a newbie to access VBA, i want to print the current record from a form, i managed to do the coding for printing current record but

when i print the button on the form it shows print preview of the current record but with no data, only controls on the reports shows not actual data. plz answer i need it.

sorry for my bad English.

i have attached the data base.

 

[vdanelia]

Hello talktime
Change Your Print Button code:

On Error GoTo Err_Print_Click
Dim stDocName As String
DoCmd.Close
stDocName = "MyReport"
DoCmd.OpenReport stDocName, acNormal 'Change acNormal to acPreview if you want to preview the report first
Exit_Print_Click:
Exit Sub
Err_Print_Click:
MsgBox Err.Description
Resume Exit_Print_Click

 

[vbaInet]

@talktime: Did you use the Report Wizard to create your report? If you didn't you should use it.

 

[r.harrison]

In the Print event you need to specify which item to print. Try this:

DoCmd.OpenReport "MyReport", acViewPreview, , "[SNo]= " & Me.lngPropertyID