Auto create of new record when accessing subform

[rbeach]

I have a form that uses an employee ID field to access information in a
subform. When changing from the main form to the subform, a new record is
automatically created in the table. I do not want a new record created, I
only need to update existing information in the subform if necessary. How do
I program to not create a new record when changing to the subform?

 

[shirley hall]

I have a form that uses an employee ID field to access information in a
subform. When changing from the main form to the subform, a new record is
automatically created in the table. I do not want a new record created, I
only need to update existing information in the subform if necessary. How
do
I program to not create a new record when changing to the subform?

 

[Sninkle]

Change the property for the subfrom from 'Allow Additions = yes' to no. This
will prevent the subform from having a new record line.

 

[rbeach]

The problem was the main form was creating the record, not the subform.
Having the combo box unbound resolved the problem.

Thanks,