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.