Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form Manipulation (2000)

    I have a form that has a bunch of fields on it. Not all of them need to be filled in every time. Then from this form a report is printed using a button on the form. My problem is, if the user tabs through and fills in the data is wants, not going through every field, and then clicks on the print report button, the report doesn't work, basically because the record hasn't been "saved" yet. Is there a way around this so the user doesn't have to tab through everything.
    Thanks,
    Deb

  2. #2
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Manipulation (2000)

    add this to the buttons code

    If Me.Dirty Then
    RunCommand acCmdSaveRecord
    End If

  3. #3
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Manipulation (2000)

    Thanks, that did it.

    Deb

  4. #4
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Manipulation (2000)

    no problem......

Posting Permissions

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