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