from and sub form based on same table

G

Gregory Hickmott

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
 
V

Van T. Dinh

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.
 
Top