problem with bookmark in relation to requery and refresh

[punky]

I am on Forma.
I open formb and have both forms in view.
I run a query in formb that will update the table that is the source of formA.
I put the following code in the close event of formb.
When I hit the close button on formb
I get the message that another user has updated the record
do I want to save to clipboard or drop update?

What am I doing wrong?

Dim varBookmark As Variant
varBookmark = Forms!frm_CatA.Bookmark
Forms![frm_CatA].Requery
Forms![frm_CatA].Refresh
Forms!frm_CatA.Bookmark = varBookmark


DoCmd.Close

 

[mrf1xa]

I suspect that running the query from form b makes Access think someone else has opened the record and updated it 'behind the back' of forma.

it may not be elegant, but how about closing forma while the user looks at form b, run the update query them reopen forma?

 

[punky]

mrf1xa,

Thank you.
Obviously, I have been at this pc tooooo long today.
It almost hit me on the head.

It works great.