Auto create of new record when accessing subform

  • Thread starter Thread starter rbeach
  • Start date Start date
R

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?
 
rbeach said:
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?
Click to expand...
 
Change the property for the subfrom from 'Allow Additions = yes' to no. This
will prevent the subform from having a new record line.
 
The problem was the main form was creating the record, not the subform.
Having the combo box unbound resolved the problem.

Thanks,
 
Back
Top