Add New Record

  • Thread starter Thread starter Paul Scott
  • Start date Start date
P

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
 
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.
Click to expand...

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.
 
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
 
Back
Top