Record Locking

[mrssevans]

I have a subform that if the selection "APT" is chosen from the combo box it pulls up a pop up form and you enter the date. All of this information goes into the same table. Here is my problem, after I enter the date on the pop up form and return back to the original form it tells me that I have a write conflict. What is this and how do I fix it? TIA

 

[John.Woody]

You open you're first form and start editing a record, then you pop up a second form and edit the same record. As far as access is concerned it might as well be a second user. When you try to update the form it tells you that it has been changed by another user. What you need to do is refresh the first form before you open the pop up form.

HTH
John