Hi,

I have a main form frmEmp and a subform sfrmEmpGeneral. They are linked
via EmpID from tblEmployees. Both forms contain data from tblEmployees. On
the main form i have a listbox that alows me to select the current employee.
There are two problems that I cannot get past...

1. I cannot update data on the subform without getting the error "Data has
been Changed" Another user has eddited this record ... but once I get this
error I can continue and the data change is saved.

2. I cannot create a new record. Not even sure how. I have created a 'New
record' button but the code gives me a blank record but It does not work
right. EmpID is an autonumber field but it does not generate a new number.

I am at a loss. The allow edits and allow additions are enabled.

Any ideas let me know,
Ernst.