Multi-user DB refreshes data in input form

[bnjoplr]

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 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

 

[bnjoplr]

Here it is, restated.

Since I posted this earlier message and haven't received any replies, I've done some research. I am now 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 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