Record Count (1 Viewer)

stu_c · Nov 7, 2019

Hi all
I have a form with a Tabular sub form but In the main form I want a record count in a TextBox can anyone help me with this?

Main Form - FRMMainDetails
SubForm - SFRMItems
Text Box - TXTNumberOfItems

theDBguy · Nov 7, 2019

Hi. Try.

Code:

=[SFRMItems].[Form].Recordset.RecordCount

Hope it helps..

stu_c · Nov 7, 2019

theDBguy said:
Hi. Try.

Code:

=[SFRMItems].[Form].Recordset.RecordCount

Hope it helps..

no that didn't work

theDBguy · Nov 7, 2019

stu_c said:
no that didn't work

What did you get? #Name?

stu_c · Nov 7, 2019

Yes mate I did

theDBguy · Nov 7, 2019

stu_c said:
Yes mate I did

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.

stu_c · Nov 8, 2019

theDBguy said:
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.

hi mate
I tried it again and that was the correct name I gave you, not too sure on the issue

theDBguy · Nov 8, 2019

stu_c said:
hi mate
I tried it again and that was the correct name I gave you, not too sure on the issue

Can you post a sample copy of your db?

stu_c · Nov 8, 2019

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

theDBguy · Nov 8, 2019

stu_c said:
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.

stu_c · Nov 12, 2019

theDBguy said:
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

Code:

=Count([ItemRecordID])

then in the main form a text back with this

Code:

=[SFRMItems].[Form]![RecordCount]

Record Count (1 Viewer)

stu_c

Registered User.

theDBguy

I’m here to help

stu_c

Registered User.

theDBguy

I’m here to help

stu_c

Registered User.

theDBguy

I’m here to help

stu_c

Registered User.

theDBguy

I’m here to help

stu_c

Registered User.

Attachments

theDBguy

I’m here to help

Attachments

stu_c

Registered User.

Similar threads

Users who are viewing this thread