updating table

[billyw]

hi..

have created a VERY simple access db.
consists of 1 table and 2 forms.
both forms are virtually the same except that on one form some of the input
boxes are locked. they show the same data on different PC's

so to the question:
if someone changes or adds a new piece of information to one of the forms
how long does it take to update.
i appreciate that you can use shift-F9 to force requery, but is there anyway
to automate this.
basically i'd like almost real time updates to each form depending on what
is happening in the other form..

does that make sense ?
thanks for any help

 

[Guest]

The table updates as you're filling in the fields in your form. However, if
another form is open based off that same table, at the time of the update, I
believe that some sort of refresh needs to happen for that second "read-only"
form can be updated. You may want to try scheduling a refresh of that data.
I find a simple macro or command that closes the form and opens it again
works best. You may want to have this done periodically. That's what I
would do, anyone else have a better idea?

 

[billyw]

thanks for that.
i've got a button that forces a requery from a macro, but would like the
requery to run every 60 seconds. dunno how to accomplish this tho..

cheers

 

[Larry Daugherty]

Hi,

Look in Help for Timer or Timer Event. You can put the same code in the
OnTimer event as you have behind your command button. A caveat: your may
have your form with only some records completed and at least one control
partially filled.

In the normal course of events, no part of a form's data is stored until the
form loses focus, as when you step to the next record. Then the entire
record is stored.

HTH

 

[billyw]

thanks larry

Hi,

Look in Help for Timer or Timer Event. You can put the same code in the
OnTimer event as you have behind your command button. A caveat: your may
have your form with only some records completed and at least one control
partially filled.

In the normal course of events, no part of a form's data is stored until
the
form loses focus, as when you step to the next record. Then the entire
record is stored.

HTH