Hi Guys

Access 2010

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...


pmtID Autonumber
pmtOrderID Foreign key
pmtDateDue
pmtAmountDue
pmtDatePaid
pmtAmountPaid
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....

Compacting
Decompile
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?

Thanks

Steve

Hi Steve,

Just a guess but see if the calculated field is on the top of the Tab Order.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

Thanks DG Guy

Umm no in the query its the last field and on the sub form its the last field tab wise and locked / set to no tab

Cheers

Steve

Hi,

I took a shot... Thanks for checking.

It might help if you could post a zip copy of your db with test data.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

What happens if you open the Query independent of the Form? Can you add new/edit existing Records?

Linq ;0)>