Hi,

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.

Any idea's?

Thanks..

N J wrote:
You cannot edit a record from two forms like that unless you make sure you
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
doing so.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

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
end if
docmd.openform "form1"

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
http://www.members.shaw.ca/AlbertKallal

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
form2.refresh
Hope that gives you enough to figure it out
Pachydermitis