BusyBeeBiker
New member
- Local time
- Today, 09:54
- Joined
- Jun 27, 2021
- Messages
- 26
A bit like a prize fighter slugging away at this one, getting a bit punch drunk so asking for assistance.
See attached screenshot:
If you look at Holidays Left (field txtLeft) it throwing the error message #Name?.
What this field should do is to generate Holidays Left based on a combinations of the fields in the sub-forms footer to generate calculated expression:
Hols Left = (Holiday Entitlement+C/F Lieu Days)-Holidays Taken
or in field terms:
txtleft = (txtEntitlement+txtHolLieu) - txtTaken
It throws out error #Name?.
The interesting thing is that if you take out the expression above from the ControlSource property and leave it blank it throws #Name?, in addition if you try to add say a string into the control source field i.e ="string" again it throws #Name?.
There are no other fields in the form that are txtLeft.
Any ideas?
See attached screenshot:
If you look at Holidays Left (field txtLeft) it throwing the error message #Name?.
What this field should do is to generate Holidays Left based on a combinations of the fields in the sub-forms footer to generate calculated expression:
Hols Left = (Holiday Entitlement+C/F Lieu Days)-Holidays Taken
or in field terms:
txtleft = (txtEntitlement+txtHolLieu) - txtTaken
It throws out error #Name?.
The interesting thing is that if you take out the expression above from the ControlSource property and leave it blank it throws #Name?, in addition if you try to add say a string into the control source field i.e ="string" again it throws #Name?.
There are no other fields in the form that are txtLeft.
Any ideas?