update statement

[rizunb]

Hi People
I am executing an update statement in vba
Once the update is done and when I go to choose any thing from any of the combo boxes on the form. following messages gets displayed.

"The Data has been changed.
Another user edited this record and saved the changes before you attempted to save your changes
re-edit the record"

Even though its only me who is using that access file.
I dont know why this is happening

 

[zevw]

After Updating use

Me.requery

 

[BillPower]

Hi rizunb and zevw,

I'm not sure how you are executing this "update statement in vba", but what I would do is:

Docmd.Echo False
Me.RecordSource = ""
Docmd.SetWarnings False
''''Run or Execute your Query
Docmd.SetWarnings True
Me.RecordSource = "OriginalTableOrQuery"
Docmd.Echo True

Bill

 

[rizunb]

It worked
Thanks

 

[Ezyflo]

Hi!

I was looking at the update statement in vba. For what I am doing, I am running my update query from a form on an "after update" event. The problem I am having is after I run the update query and return to my orignal record source for my form, it changes the record that I was on to the first record of my from instead of record "111" that I was working on. Is there a way to store the record ID and after running the update query, have it return to the record that I was working on? If so, what would be the code? Any help would greatly be appreciated.

Thanks!

D

 

[zevw]

Ezyflo!

I responded to this problem in Thread #

thread705-612488

Check it out!

 

[Ezyflo]

Cool Beans!!!

Thanks!!!