Open Form Add New record

[DMerchen]

I have been working on a timesheet program, and I believe I am pretty close to being completed with the input functions, but I have run into a snag. I have a form that basically directs a person to add a new timesheet or edit an old timesheet. I have two comboboxes and I have been able to set up a filter to be able to edit a timesheet based on the selections. Choose the selections and hit the button and a new form opens where you can edit your times. I am unsure how to do the new record. I want to be able to choose the criteria in the comboboxes which are name and date and then open a new form to add times to the new timesheet. When I open the form I can't figure out how to add a record and get the date and the employeeID to the proper textboxes so the timesheet is saved properly. I hope this makes sense. I am trying to make this secure so I am having them enter a password so there is a certain sequence of events I believe I need to follow. Some of you Access Gurus may have a better idea.

 

[DMerchen]

I decided to load the database so that you can have a closer look at what I am trying to describe. If you start out at the form Navigation and choose new you can follow the path basically. Simply choose a name and a date on the next form enter 123456 as the password and it will open the timesheet. Please do not laugh at my amature attempt. It has been a while since I worked in Access. Sorry I had to add it as a zip file, couldn't get the database file to load even though it is below the required size.