I've used tabed pages to make things easier ( the tabs can contain fields of
the same table or they can contain subforms)
"Jim Bunton" wrote in message
...
The concept of a sub form is generally applicable to the situation where
you
want to "link" information that is in two tables (not one). An example
might
be an invoice (one table) and the items on the invoice (another table)

[eg Invoices - invoiceId, invoice date InvoiceItems InvoiceItemId,
InvoiceId, ItemDescription, ItemCost.] These would llink on InvoiceId. The
main Form would be a single record form and the subform mulitiple records.

In the case you are describing:
There ar two options (at least!)
1. Use two forms - one for 'Basic' information and anothe for 'detailed'
information
[you could open the second from the first BUT don't allow edits of the
same information on each form or you will likely get the same 'error' as
you
are getting now]
2. Put all the information on one form - then, write some code to
'collapse'
the more detailed information [make the controls have zero size and move
them and make them invisible and while you are doing this have in mind the
code to resize them and move them to the original positions and make them
visible - which you can put into the click event for a button on the
always
visible part of the form.

Jim Bunton

"Ernst Guckel" wrote in message
...
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.