Repost-Help with Forms not updating

Hello,

This is a repost, is anyone able to help me with this.
Thanks very much,
IEJ

We have a Call Centre with three entry clerks all taking
appts and recording installations. We have a Main Form
for staff to bring up an address (underlying table is
tblHouses)and assigning it a Call ID. Next procedure is
to open Appt Booking Screen from a selection box, detail
the appt and close and return to main form. After
installation is completed staff will select the specific
Call ID that had been assigned for the address, and using
the Open Installation button, open the installation
screen, fill out all the detail, close, close appt screen
and return to Main Screen.

What is happening is they enter the first install, close
and return to the Main Form and start a second install
and immediately get a error message box reading something
like, "You and another user are attempting to change the
same record....etc."

It seems like it is updating the information to the
tables underlying for installs and appts but it seems
like it may not be updating the tblHouses on the Main
form. It seems to work okay as long as they close all
screens after each install and reopen the Main Form.
This is arduous and time consuming.

I think what needs to happen is on Save and Close of the
Installation screen, the underlying tblHouses closes or
requeries or something to make it move off the record its
on so they don't get this message.

Is anyone able to help me with this and give me some
direction to what might be going on.

Thanks very much,
IEJ

Your description suggests that the record being edited on Main form is not
being completed -- instead, it's remaining in edit mode? Can the button code
that opens the Installation form (in dialog mode, I assume?) then make the
Main Form move to a new record? Or at least save the current record?

I must admit that I'm not fully "seeing" your process in my head from your
description, so how to do what I suggest may differ if the setup is
different than I'm assuming it is.
--

Ken Snell
MS ACCESS MVP

"IreneJ" wrote in message
...
Hello,

This is a repost, is anyone able to help me with this.
Thanks very much,
IEJ

We have a Call Centre with three entry clerks all taking
appts and recording installations. We have a Main Form
for staff to bring up an address (underlying table is
tblHouses)and assigning it a Call ID. Next procedure is
to open Appt Booking Screen from a selection box, detail
the appt and close and return to main form. After
installation is completed staff will select the specific
Call ID that had been assigned for the address, and using
the Open Installation button, open the installation
screen, fill out all the detail, close, close appt screen
and return to Main Screen.

What is happening is they enter the first install, close
and return to the Main Form and start a second install
and immediately get a error message box reading something
like, "You and another user are attempting to change the
same record....etc."

It seems like it is updating the information to the
tables underlying for installs and appts but it seems
like it may not be updating the tblHouses on the Main
form. It seems to work okay as long as they close all
screens after each install and reopen the Main Form.
This is arduous and time consuming.

I think what needs to happen is on Save and Close of the
Installation screen, the underlying tblHouses closes or
requeries or something to make it move off the record its
on so they don't get this message.

Is anyone able to help me with this and give me some
direction to what might be going on.

Thanks very much,
IEJ

On Sun, 4 Jul 2004 11:47:09 -0700, "IreneJ"
wrote:

I think what needs to happen is on Save and Close of the
Installation screen, the underlying tblHouses closes or
requeries or something to make it move off the record its
on so they don't get this message.

You can explicitly force the mainform record to be saved to disk. I'd
suggest in the code that opens the second form including a line

If Me.Dirty = True Then Me.Dirty = False

which is one of several ways to do so.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public