Add New Record

[Paul Scott]

I'm trying to develop a form for employee training.
Instead of typing the employees name I'm trying to use a
drop down box. The problem I'm having is when I try to
enter a second new record.

When I add the first new record to J Smith everything is
fine. When I open the form again and click on J Smith in
the drop down box again to enter another new record the
first records data appears. Instead of letting me enter
new data it's displaying the current data.

I use On Click docmd.GoToRecord , , acNewRec

I know I'm not doing something simple but for the life of
me I can't figure it out.

Any help would be appreciated.

Thank,

Paul

 

[John Vinson]

I'm trying to develop a form for employee training.
Instead of typing the employees name I'm trying to use a
drop down box. The problem I'm having is when I try to
enter a second new record.

When I add the first new record to J Smith everything is
fine. When I open the form again and click on J Smith in
the drop down box again to enter another new record the
first records data appears. Instead of letting me enter
new data it's displaying the current data.

I use On Click docmd.GoToRecord , , acNewRec

I know I'm not doing something simple but for the life of
me I can't figure it out.

A Combo Box will simply update the employee ID of the record on the
screen if it's a normal bound combo.

If you want to enter an employee's ID using the combo box, navigate to
the new record *first*, and then select the name.

If you want to use a combo to find an existing record (without
modifying anything in the current record) the combo must be unbound
and have a bit of VBA code to synchronize the form to the selected
record. The Combo Wizard will set this up for you.

 

[Paul Falla]

Dear Paul

Use the same code on the "On Open" event of your form.
This way your form will always open at a new record.

Hope this Helps

Paul Falla