#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jan 2013
    Posts
    1
    Rep Power
    0

    Tab through access form deletes form data


    Hey - I'm having a problem on accidentally deleting the data from a form I fill in in access. When I press tab, enter, arrow, etc. (all the shortcuts to move to the next field) once I get to the last box, if I press any of those options that take you to the next box, it goes to the first field and deletes all the data I have typed in. I'm sure it's just a simple setting or I need to insert something that is specific as a last field, but I cannot for the life of me figure out how to do it. Basically, I don't want the next field shortcuts to clear the information when it goes from the last field to the first. I've looked online and haven't been able to come up with much, it's hard to research such generic terms.

    The only thing that came close to looking like a solution was the client settings of access options but I tried changing a few of the options there and nothing made a difference.

    Help please!
  2. #2
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    59
    It's not really deleteting what you typed in. If you check your table it's most likely still there. It's moving on to the next record. You can change this by going to properties, under the 'Other' tab, you'll see a property called cycle. It's default is 'All Records', change it to 'Current Record' and it shouldn't do that anymore.

Similar Threads

  1. Replies: 5
    Last Post: September 19th, 2012, 02:35 PM
  2. Can not add data from ASP form using Access 2007
    By lfrydland in forum ASP Development
    Replies: 8
    Last Post: December 23rd, 2009, 05:38 AM
  3. Send form data to and reading data from access database
    By cyrilallen in forum ASP Development
    Replies: 3
    Last Post: January 22nd, 2007, 06:46 AM
  4. Replies: 10
    Last Post: December 5th, 2006, 09:35 AM
  5. populating a form with data from Access
    By Steve Schofield in forum ASP Development
    Replies: 2
    Last Post: August 21st, 2001, 12:58 PM

IMN logo majestic logo threadwatch logo seochat tools logo