G
GTCMOM
Hi,
I have a main form with a subform imbedded in it with a typical parent-child
relationship. The main form references tbl_Payers, the subform references
tbl_Override, a table with FK PayerID and FK CPT from another table, plus a
pricing field and notes. The subform is in datasheet view with "yes" for
allowing additions, deletions, or edits. It was allowing users to do so
until I made these changes: I added an unbound control on the main form
referencing item count from a hidden control in the subform's footer. I
added a unique index on tbl_Override called "Entry ID" on PayerID and CPT to
prevent duplicate values. I can not find any reason when the form and
subform are open the subform datasheet users can not makes changes to the
table. Many thanks!
I have a main form with a subform imbedded in it with a typical parent-child
relationship. The main form references tbl_Payers, the subform references
tbl_Override, a table with FK PayerID and FK CPT from another table, plus a
pricing field and notes. The subform is in datasheet view with "yes" for
allowing additions, deletions, or edits. It was allowing users to do so
until I made these changes: I added an unbound control on the main form
referencing item count from a hidden control in the subform's footer. I
added a unique index on tbl_Override called "Entry ID" on PayerID and CPT to
prevent duplicate values. I can not find any reason when the form and
subform are open the subform datasheet users can not makes changes to the
table. Many thanks!