from and sub form based on same table

when changing data on the form that has a sub form based on the same table
im getting a error that the data has been changed by a second user the form
is a subset of the sub form data when looking at the from im looking only at
a small part of the table but the sub form has more of the data

The main Form is one "user" and the Subform is another "user".

The easiest way is to make either the main Form or the Subform "Read-Only"
and do the editing in the other.

--
HTH
Van T. Dinh
MVP (Access)




"Gregory Hickmott" wrote in message
...
when changing data on the form that has a sub form based on the same table
im getting a error that the data has been changed by a second user the
form
is a subset of the sub form data when looking at the from im looking only
at
a small part of the table but the sub form has more of the data