Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011

    Unanswered: Report prints only the controls not actual data, why?? :eek: i need it urgently

    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.
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2009
    Kerala, India
    A small correction was necessary on the Open Report action code:

    DoCmd.OpenReport "MyReport", acViewPreview, , "[SNo]= " & [lngPropertyID]
    The corrected database is attached.
    Attached Files Attached Files (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts