I am using Access 2007 and created a split form based on a table. There is a field called cost code. A cost code may have one or several records from this table. I created a combo box based on cost code to select the records that appear on this form.
I have raw data (hours) from the table on this form. There are calculated controls on this form that are look-ups of data (rates) from an imported table, as well as other calculated controls which multiplies the looked-up data against the raw data. There is also a control called Extension that sums up all these latter calculated controls.
In the datasheet view I have intentionally hidden the calculated controls but show the Extension control. It is designed so the user can make changes to the raw data in the Form view area and thereby get a new Extension amount.
Whenever I use this form it works fine and with no performance issues. It seems quite fast!
However, when another user opens this form all the calculated controls in the Form view come up blank as well as the Extension control, even when they make a selection from the combo box. But if they click on any Extension control a calculation appears, and the calculated controls get populated.
Why is that?
I have raw data (hours) from the table on this form. There are calculated controls on this form that are look-ups of data (rates) from an imported table, as well as other calculated controls which multiplies the looked-up data against the raw data. There is also a control called Extension that sums up all these latter calculated controls.
In the datasheet view I have intentionally hidden the calculated controls but show the Extension control. It is designed so the user can make changes to the raw data in the Form view area and thereby get a new Extension amount.
Whenever I use this form it works fine and with no performance issues. It seems quite fast!
However, when another user opens this form all the calculated controls in the Form view come up blank as well as the Extension control, even when they make a selection from the combo box. But if they click on any Extension control a calculation appears, and the calculated controls get populated.
Why is that?