Forms with SubForms Issue

[dsellers1]

Access 2007

I am currently working on a database that tracks what an individual does during the day. I have created a very simple form called frmOperatorLog that includes 4 subforms: fsubProduction1, fsubProduction2, fsubProduction3, and fsubProduction4. The main form doesn't write any data to the table but the subforms do. In fact, all four subforms will write to the same table. They are very simply subforms that only include a combo box for the queue that they work in, a text box that they would log their case count in, and a text box that they would log the available minutes in.

Each subform's data entry property is set to "Yes" with the Record Locks property set to "Edited Records". I have 5-10 users that access this form at one time and I normally don't have issues. On occasion, if the form is left up for any length of time, it will autofill all four subforms with old data previously written to the table and it will all be the same data across all subforms.

I have tried to recreate the issue but never can seem to do it. Any thoughts on what it could be? I have messed around with various properties on both the main form and the subform but it never seems to fix it. If you need the complete property data, just let me know

 

[vbaInet]

So how is your database shared between the users? Sounds like you have it on a shared drive?

 

[dsellers1]

It is on a shared drive. Please don't tell me that's the issue...

 

[vbaInet]

I'm glad you know I was getting at that No matter how simple the db is, it must be shared in the appropriate way.

 

[dsellers1]

So let me ask. Would there be anything I could do other than splitting the database? Aside from just expecting this issue? Of course, I think I already know this answer

 

[vbaInet]

You already know that I won't advise otherwise

But you have another problem too. Why are the subforms feeding from the same source?

 

[dsellers1]

They may work in up to four different areas throughout the day. By having it write to the same table, I was avoiding the extra queries. Probably not the best approach looking back on it...

I do thank you for your help!

 

[vbaInet]

You can use the same subform but filter it accordingly via a Combo Box. So they choose the area that wish to report on, and the subform changes accordingly.