Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    85

    Unanswered: Printing problem

    Hello, I all the sudden developed a proplem with printing, Have bound(autonumber) form which I send to a report with following code

    Private Sub Command101_Click()
    DoCmd.OpenReport "rptBuildSheet", , , _
    "ChairBuildDetailsID = " & Me.txtChairBuildDetailsID.Value
    DoCmd.GoToRecord , , acNewRec
    Exit_Command101_Click:
    Exit Sub

    Print form but w/out Data

    Any help please

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Quote Originally Posted by Timothyl
    DoCmd.OpenReport "rptBuildSheet", , , _
    "ChairBuildDetailsID = " & Me.txtChairBuildDetailsID.Value
    DoCmd.GoToRecord , , acNewRec
    I believe you're telling it to go to a new record, which won't have data until you enter it in.
    Me.Geek = True

  3. #3
    Join Date
    Apr 2009
    Posts
    85
    nckdryr, I thought of that and removed it but did not help, this fixed it

    RunCommand acCmdSaveRecord
    Form.Repaint

    It just needed it out of the blue ?, I tested the code before using it live, as priour to printing with a report I was printing from the form. Thanks for responding was in a small panic about it

Posting Permissions

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