Record Count

[stu_c]

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]

Hi. Try.

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

Hope it helps..

 

[stu_c]

Hi. Try.

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

Hope it helps..

no that didn't work

 

[theDBguy]

no that didn't work

What did you get? #Name?

 

[stu_c]

Yes mate I did

 

[theDBguy]

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:

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

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:

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

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]

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]

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]

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

=Count([ItemRecordID])

then in the main form a text back with this

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