Hook'D on Access We have a problem with Run Query from 2 Forms Thread from last week

[puforee]

Hook'D

The code you gave me works...so no problem with the SQL or calling it.

The problem is, when I close the MsgBox "Data updated" dialog box I get this dialog box:

Write Conflict
This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.

Coping the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes.
How can I suppress this. Remember I have 8 to 10 training dates to update on my form and I will have the SQL function you provided for each....modified of course for the data related to that training subject.

I have tried saving from the function but it does not like that. I have come back to the Call code and put a DoCmd.Save after that...still did not fix the problem.

Can you help this one last time please.

 

[dhookom]

I don't recall all the specifics of our previous conversation.

I would make sure you save the current record prior to any action queries that might update the records bound to the form you have open. You can save the current record with code like:

Me.Dirty = False

Duane
Hook'D on Access
MS Access MVP