I have a a form with many calculated controls on it. The form works perfectly.
I recently split the database into front and back ends and installed it on a client's network. The front end is installed on each user's pc and the back end is on the server.
However, when the users open the form, one of these calculated controls, always shows #Type!. The other calculated controls work without error. If the form is refreshed with F5, the error goes away and the control then shows the correct value.
I initially thought that the control might be trying to perform the calculation before the data is loaded into the form, so I tried making the form requery and/or refresh on the Open, Load and Current events, but that didn't help.
I have tried duplicating this on my own network and I can't duplicate the error.
If I connect to the backend remotely using something like Teamviewer, I can't get the error. It only happens on the client's own network.
For what it's worth, here is the code for the controls:
The control which shows the error has a control source of:
The control source for txtIncome is:
The control source for txtExpense is:
At this point I'm not even sure where to look to correct this problem. Does anyone have any idea of what might be going on here?
Thanks
I recently split the database into front and back ends and installed it on a client's network. The front end is installed on each user's pc and the back end is on the server.
However, when the users open the form, one of these calculated controls, always shows #Type!. The other calculated controls work without error. If the form is refreshed with F5, the error goes away and the control then shows the correct value.
I initially thought that the control might be trying to perform the calculation before the data is loaded into the form, so I tried making the form requery and/or refresh on the Open, Load and Current events, but that didn't help.
I have tried duplicating this on my own network and I can't duplicate the error.
If I connect to the backend remotely using something like Teamviewer, I can't get the error. It only happens on the client's own network.
For what it's worth, here is the code for the controls:
The control which shows the error has a control source of:
Code:
=Nz([txtIncome]-[txtExpense],"")
Code:
=DSum("Amount","tblIncome","[ProjectID]=" & [Forms]![frmProjects]![ProjectID] & "AND Not([Date] Is Null)")
Code:
=DSum("Total","tblExpense","ProjectID=" & "Forms!frmProjects!ProjectID")
Thanks