Results 1 to 2 of 2
  1. #1
    excal is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2011
    Posts
    7

    Access noob needs some help with Microsoft Access: Forms and primary key

    I'm creating a database for a project, and this form is for creating new records in the employee table. The primary key is the employee ID.



    The form is somewhat working, and updates the table when I click on the command button. However, the info stays there, and I want the form to clear to be ready for the next input.

    Also, another issue I ran into is with the info there, I tried to just delete it manually and input new stuff. However, the new info overwrites the old info, and doesn't insert a new record at all.

    any reason why this is happening? Access noob here

    this is a bound form, and while we learned a lot about database theory, we've really done no practical work and being thrown into an assignment like this really threw me off

    Help would be much appreciated

    SELF SOLVED VIA GOOGLE: Added:
    DoCmd.GoToRecord , , acNewRec
    Me.Text98.SetFocus

    To the afterupdate field.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You could also set the DataEntry property of the form true and achieve the same results.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 11-22-2011, 05:23 PM
  2. Replies: 0
    Last Post: 02-08-2011, 02:34 PM
  3. Microsoft Access Relations Ships and Forms
    By rajgoyal00 in forum Forms
    Replies: 6
    Last Post: 11-21-2010, 10:09 AM
  4. Replies: 1
    Last Post: 06-20-2010, 05:04 AM
  5. Microsoft Access Forms
    By hajvery in forum Queries
    Replies: 1
    Last Post: 01-06-2010, 11:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums