Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    292

    Unanswered: how to Go to the Next Record ?

    Hi,

    I have a form which has unbound fields.. On my form .... I'll let the user enter in new data for a record.. click the add button.. my problem is.. after the user hits the add record button.. it does save all info to table.. but the original info that the user entered stays there.. I want it to go to the next record.. or blank the form out .. that way.. the user can enter in the second record..

    I made the fields unbound in order to stop the user from scrolling records with the mouse wheel.. that was fine until I came to a problem with the numbering of my records..

    I'm now using a function to call unique numbers and assigning them to each record.. but doing that made the mouse scroll again! So what I did was.. turn my "allow addition" event to No.. and that fixed the scrolling..

    What my main concern is after the user enters in the new record and clicks "add" -- I would like for the form to blank out with the exception of my unique number function.. which is there to number my record.. I want that to jump to the next record ---which it does already but the form does not blank out.. whatever the user entered in last .. that what they see when they click add which I want to blank out...


    sorry about the long post.. I just wanted to fill you in on what I did...


    Thanks for any help

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    After your save operation, add some code to set each field to Null

    ...

    Me.Field1=Null
    Me.Field2=Null
    ...

    I've read somewhere before that you can use Me.Undo,
    but I've never tried that with an unbound form.
    Inspiration Through Fermentation

  3. #3
    Join Date
    Jul 2003
    Posts
    292
    Thanks RedNeckGeek,

    This did work ! .. but is there a way you can do it with one shot ?.. instead of having to do that for each field ??

    thanks

Posting Permissions

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