Check boxes slow to update on form

[stevekos07]

I have a form with a list of locations that we use to show which have checked in and out every day. I have check boxes for each record for this purpose. One problem we are encountering is that if one user checks one of these boxes, it can take a very long time for this to show on other users' versions. The form always updates eventually but it can take up to 5 full minutes for this to happen, causing confusion for the users. This problem is unique to this form, other forms with check boxes have no problems.

What should I look for in the form or underlying table and query to find what the problem could be here?

Perhaps I should use another option such as a Y/N combobox?

 

[jdraw]

Tell us about this multiuser database.
Is it split into Front end/back end?
Is there a copy of the front end on each user's PC?

 

[stevekos07]

The database is split with all tables in a back end and each user with a separate copy of the front end.

 

[jdraw]

Can you show us some code associated with the "problem form"?

 

[stevekos07]

What would you want to see? It is a fairly simple form with a list of locations in text fields with associated fields in the table for various options in comboboxes. The comboboxes are form based, not lookup fields in the tables.
The checkboxes are simple Yes/No fields with no programming. There is some conditional formatting based on the selection of the checkboxes but nothing complex.

 

[stevekos07]

I just had a look at the source table and noticed something odd. The first record was blank. I deleted it, and it seems that this might have fixed the issue. I'll wait to see what happens

 

[stevekos07]

Mmm. No such luck. Still taking a long time to refresh. It's not all of the time, just occasionally. Some times the form refreshes in a couple of seconds, other times it takes quite a long time.

The issue might be our network, but this is the only form that consistently performs so badly.

 

[jdraw]

If it's only 1 form and sporadic, I would think there ma be some network load issue somewhere???

 

[stevekos07]

Thanks jdraw. That may be the problem. It may be as simple as some minor error in the coding behind the table or query or form itself that doesn't register as an error but affects the operation somehow.

This object is new to the database and is still in test mode alongside a manual system still in use. I could rebuild everything from scratch to see if it remains a problem, but there is nothing obvious in the SQL or any VBA coding. It won't take me long to rebuild everything, so I think I'll try that and see if I still get the same problems.

I have read that from time to time various design elements can cause unpredictable spontaneous glitches, but no specific fixes have been offered for checkboxes on simple forms that I have come across.

 

[jdraw]

This object is new to the database and is still in test mode alongside a manual system still in use.

This puts the issue into a new light.
Since it's new, it is the obvious place to look.
Do some investigative debugging --use some debug.print statements.
Is there a complex recordsource? Are you using a number of Domain aggregate functions(DSum, Dcount, ....etc)? Are you making calls to functions, perhaps inside loops?
Just a few things that may highlight an issue. Good luck.