I have a simple sub form that lists a payment plan for the client. The sub form record source is based on saved query and contains the following fields...
pmtOrderID Foreign key
OSBal - Calculated field in query [pmtAmountDue] - [pmtAmountPaid]
However every time a user enters a new record they get an error message "field cannot be updated". if the user presses ok they can continue to enter the new record, however this is not ideal.
By removing the calculated field OSBal from the query everything works fine. With the calculated field i have tried the following without any luck....
Being in as only user on system
I have seen a number of posts here about this but no solution and would be nice to show the os balance for each line.
Can anyone help please?