Need blank record on form

[thart21]

I have a form with a drop down of employee names and a tabbed subform.

I have the form and subform set up to open on a new record and, when the employee name is selected to fill the subform with that employee's data.

It is a split db with the be on the network server and everyone has their own copy of the fe. When I open the front end the combo box is blank but the first page on the tabbed subform shows data. If I close it and reopen it, sometimes its blank and other times it still shows data.

What else do I need to do to ensure that it is a blank record?

Also, I am using the MouseHook.dll and included it in my .exe (zip) file to all of my users, instructing it to download to the same location as the .mdb file (C:/Training Database). Will this work or does the MouseHook.dll need to be somewhere else?

Thanks,

Toni

 

[thart21]

Pat,

The subform automatically appears when the main form is opened. In the "Form_Load" event I have "DoCmd.GoToRecord , , acNewRec".

Should I try to have the subform stay closed until the "After Update" event of the Employee name combo box?

If I change it to "Data Entry" only won't that only allow new records to be added and will not allow the user to see all of his records and modify them?

The subform's list training items with two fields that they will modify - one to enter a date completed and another to enter total hours for training.


Thanks,

Toni