updating data on tab pages

[mbr96 via AccessMonster.com]

I have a form with a tab control with multiple pages. When a value is
selected on a control on one of the pages, several related values are filled
in on other pages. I've tried this with a macro that sets a value based on a
dlookup, and I've also done it with an update query based on the same dlookup
amount. Either way works until I click onto another page on the tab control.

When I click to one of the other pages it says "This record has been changed
by another user etc." and gives the choices to drop the changes, save the
record,etc.

I tried adding a saverecord command after running the macro that updates the
existing record, but I still get that message. I also tried putting a
refresh / requery on the on click of the page containing the changed fields,
same result.

Any ideas?
MBR

 

[Guest]

The "related fields" that were filled in have not yet been saved, and that's
why you are getting the "another user" stuff. I'm not familiar with macros,
but in event procedures you can stick in a "Save" statement that will solve
that problem. Perhaps you can do the same with a macro. I hope that makes
sense.