Field in the form cannot be updated (1 Viewer)

yeowkev19

New member
Local time
Today, 01:57
Joined
Dec 21, 2019
Messages
7
Hi All!

I have a query with calculated fields and I can update it when I go to the new record. But when I apply it to the form it cannot be updated. When I click on the AddNew button in the form it goes to the control TransactDate, and when I click on the datepicker, it displayed the error message saying "field cannot be updated". I have checked the property and it is not locked.
Also as shown in the attached screenshot, I have 3 calculated fields that displayed #Num! in the respective text boxes.
I am puzzled and tried different ways to eliminate that but could not.
Please anyone knows the reason?
Thanks
 

Attachments

  • 2020-01-15 (1).jpg
    2020-01-15 (1).jpg
    92.5 KB · Views: 375

theDBguy

I’m here to help
Staff member
Local time
Today, 01:57
Joined
Oct 29, 2018
Messages
21,357
Hi. Calculated fields are read-only. I don't understand how you were able to update the data/value in the first place. Where/How are you doing this, where you can change the value in the calculated field? You don't mean updating the other fields used for the calculation, correct?
 

Users who are viewing this thread

Top Bottom