Echo? Paint? Repaint? multi-user db forms keep refreshing

  • Thread starter Thread starter Bobbi
  • Start date Start date
B

Bobbi

I am wondering if any of the following properties will help with my problem:
Paint, Repaint, Echo, Requery. Comments, please!

I developed a database that is used to track road conditions during weather
events. The data input form starts with a lookup to the streets table, then
they tab to the subform to record info such as caller name, specific
problem, etc. My problem is that Access refreshes the info, so one user
might be inputting info for Main Street and in 1-60 seconds, another user's
lookup field will change to the Main Street record. I don't want this to
happen.

I just split the database and copied the front end to the C drives, thinking
that if they weren't looking at the same form, that would fix it. It didn't.
Is changing the refresh rate the only way around this? Are there any known
performance issues with changing that rate? Any insight would be
appreciated.

Bobbi
 
Bobbi said:
I am wondering if any of the following properties will help with my
problem: Paint, Repaint, Echo, Requery. Comments, please!

I developed a database that is used to track road conditions during
weather events. The data input form starts with a lookup to the
streets table, then they tab to the subform to record info such as
caller name, specific problem, etc. My problem is that Access
refreshes the info, so one user might be inputting info for Main
Street and in 1-60 seconds, another user's lookup field will change
to the Main Street record. I don't want this to happen.

I just split the database and copied the front end to the C drives,
thinking that if they weren't looking at the same form, that would
fix it. It didn't. Is changing the refresh rate the only way around
this? Are there any known performance issues with changing that rate?
Any insight would be appreciated.

Bobbi
Click to expand...

It sounds to me as though your street lookup control (a combo box?) is a
bound field when it shouldn't be. Is the main form bound to a table?
If so, why? Does it serve as anything other than a container for the
subform, with the street lookup control serving as the link master
field?
 
Back
Top