Updating same record with two forms

[puthenveetil]

Dear all,

Is there any way to update the same record from two forms? The requirement is that in a form I have a checkbox. If I select the checkbox, it will open another form, in which I can update some fields which are of the same record. When I tried, it is updating on another record. Is that possible to do so?

i am attaching a sample db . If anyone knows how to do it, please update the sample db or give me advice.

Thanks

 

[workmad3]

You seem to be running afoul of record locking. The way around it would be to disable record locking, but before you do this, think carefully about what you database is going to be used for and by. If there is ANY chance that the record could be updated by 2 people at once, you should try a different solution, possibly by using a subform that becomes visible when you check the checkbox.

Hope this helps a bit