reports not prints data

[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.

[RuralGuy]

Is this what you used to print the current record? http://access.mvps.org/access/reports/rpt0002.htm

[talktime]

not the same, a little different but that code is doing well as for as current record is concern, it only do not prints data, coz when i click the print button on the form, it shows the preview of the report, which shows only controls not the actual data, i have attached the database so you can have a look at it. plz solve my problem

[RuralGuy]

See if this works any better.

[talktime]

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

first of all thanks a lot!!! and plz could u explain what is the difference in my code and this code, coz that code was showing print preview but no data. and where my code was doing wrong.

[RuralGuy]

Your code was pointing to the form but not the control on the form that contained the [SNo] value you needed. You could have also used:
DoCmd.OpenReport "MyReport", acViewPreview, , "[SNo]= Forms!Details.lngPropertyID"

[talktime]

thanks a lot buddy!!!!

[RuralGuy]

Glad we could help. It looks like you are from the UAE. Welcome to the Forum.