I thought so, that means you may have had a typo, or you didn't give us the name of your subform control. So, the syntax has to be something like this:
Code:
=SubformControlName.Form.Recordset.RecordCount
The subform control name may or may not be the same as the name of the subform it contains. But if you got a Name error, then it's probably different.
I thought so, that means you may have had a typo, or you didn't give us the name of your subform control. So, the syntax has to be something like this:
Code:
=SubformControlName.Form.Recordset.RecordCount
The subform control name may or may not be the same as the name of the subform it contains. But if you got a Name error, then it's probably different.
Not my actual Database but an example of it and in the same format, I want the number of items in the main form to count the number of records from the sub form
Not my actual Database but an example of it and in the same format, I want the number of items in the main form to count the number of records from the sub form
Okay, sorry, I guess Recordset is not available in the Control Source anymore. Instead, I gave you a different approach. Please take a look and let me know if you have any questions.
Okay, sorry, I guess Recordset is not available in the Control Source anymore. Instead, I gave you a different approach. Please take a look and let me know if you have any questions.
Afternoon Mate
thank you for the reply, that's kinda what I need but it seems to only update when I move onto another record and back, also is there a way for that value to be saved into the table?
I managed to do it this way cheating I know but still doesn't save to my table
In the Subform (SFRMItems) I have a
text Box named - RecordCount
with this code