Save or Drop Record? - 07-04-2005 , 04:00 PM
I have 2 forms open at the same time, Form 1 adds information to a field on
a record that Form 2 has open. It used to show the new information on Form 2
straight away in a text box but now it doesn't, and when I go to close Form
2 after making changes to other fields, it asks if I want to Drop or Save
changes made by another user.
Re: Save or Drop Record? - 07-04-2005 , 04:18 PM
N J wrote:
commit all changes in the first form before opening the second form and then
commit the changes from the second form before returning to the first one. Two
forms editing a record at once is no different (to Access/Jet) that two users
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Re: Save or Drop Record? - 07-04-2005 , 04:31 PM
When does form 1 add this info? At what point, or how does this happen?
If form1 is being called from from2, then you need form 2 to issue a disk
write before form 1 is launched.
you can go in the code
if me.Dirty = true then
me.dirty = false ' force a disk write
So, you just have to coordinate this a bit better. If another user, another
form, or even some code, or even a query modifies the data in the form that
you are working on, then you are going to get a message that someone,
something etc. changed the data.
So, just make sure you write out the data before that other stuff runs.
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal (AT) msn (DOT) com
Re: Save or Drop Record? - 07-04-2005 , 07:50 PM
It sounds like you have a record on form2 that has not been saved. Do
you write code?
On your before update event for form1
form2.undo 'undo any changes that will upset form 2
On the after update event for form1
Hope that gives you enough to figure it out