Hi Everyone,
I have 2 forms one is for user administration which opens the other form user modification.
"Form user administration" has buttons to add,delete,modify user and the user data comes from a table Users in splitview,with usertype and username fields.
When user selects a record and clicks "modify" the values of selected record are sent to open modify form with selected record as openargs
"Form User Administration" is open in the background but cant be edited,closed etc.
"Form modify user" now opens up with the openargs values and places these values in existing user textbox for usertype and username and there 2 fields for typing new username and usertype so that existing gets replaced with new ones. There is button called modify now on "modify form" which when clicked is showing write conflict error dialog saying 2 save changes,copy to clipboard,discard changes. if i save record, search key is not found error appears later, if i discard unknown changes to other users takes place.
I tried event on deactivate for both forms with vba code DoCmd.RunCommand acCmdSaveRecord but nothing is solving my problem.
I tried to set record locks property "Edited Locks" in Data Tab of Property sheet for the forms in design view. It still shows the same problem.
there is some problem when i try to work on the same record in 2 forms.
Pleeeease Help.