Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Blank a form using a command button (2000 / 2002)

    Question - How do I blank out a form or reset it so that new data can be entered after the old data has been viewed?
    Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Blank a form using a command button (2000 / 2002)

    Bound or unbound form? Are you trying to add a new record, change data in an existing record, or what?
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Blank a form using a command button (2000 / 20

    The form is bound to a query - it has check boxes that run a make table query and then lets you preview a report. When you exit the report it returns you to the form - I would like to create a button the clears all the check boxes so that a new report can be run - but I would like the user to be able to do this when they are ready - by clicking on a command button.
    Robin

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Blank a form using a command button (2000 / 20

    I'm sorry but I don't understand. If the form is bound to a query, what do the checkboxes do? Are the controls bound to fields in the query? Are you displaying data in the form before creating a report, or what?
    Charlotte

Posting Permissions

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