Anyone have experience? Help! I have to modify a lousy
wizard-generated permit-issuing program to require a second user login
and password to “void” a permit once issued. There’s a main form, and
sub form involved, with permit details on the sub form, permittee and
“amounts paid” on the main form. When I update a permit to “Void”
status on the sub form, all works okay, including setting the “paid”
text boxes on the Main form to “$.00” (though not yet “saving” such
changes to the database.) The problem comes when I lose focus from the
sub form back to the main form (by clicking anywhere outside the sub
form.) I get a system generated pop-up that says “Write conflict:
another user has modified this record since youbegan editing it.
Either click ‘Save Changes’, and overwrite the other users changes, or
“Drop changes”, or “Copy to clipboard” to see the changes the other user
made.” I get this whether I do my DoCmd.DoMenuItem, acRecordMenu,
acSaveRecord, etc. on the sub form, or on the main form (in the Private
sub OnExt_SubForm() event function). Anyone have any ideas? I’ve
consulted books, help and four other VB programmers here – and no luck.
Thanks.
