Hello Experts. I have an issue which is out of my area of expertise and could really do with some expert help, so thanks in advance:
I have some code which is meant to update some values in a subform. The recordset I am using must refer to the values in a calculated control on my subform - and this is what I am struggling to do.
How do I refer to my calculated control from with a recordset?
This is my current code:
Dim rsc As DAO.Recordset
Set rsc = [frmAllocateToBuildComponentSub].Form.RecordsetClone
Do Until rsc.EOF
rsc!stockcheckqty = *** SOMETHING LIKE THIS : stockcheckqty - mycalculatedcontrol) ***
If it helps here is a snip of my button and the controls I want to refer to: