Looking for way to count records in subform and display in form

[ccmandel]

I have seen many posts about this but can't seem to get a grip on how to do this. I don't have visual basic experience.


I want to be able to count the records in a subform and have this field visible from the form.

Main form: Data Entry Form
subform: Contactinformation subform

Many thanks . .

 

[PHV]

As you said many posts cover this subject.
What have you tried so far ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ccmandel]

I have just copied suggestions that I have found online . without any real understanding of the hows and whys . (not a great technique) . .

Dcount
Count
creating text box on subform . . referencing it on main form . .

 

[ccmandel]

I tried this too: Forms!frmMyForm!SubFormControl.Form.RecordsetClone.RecordCount

 

[PHV]

creating text box on subform . . referencing it on main form
This is the most common way.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ccmandel]

Could you explain it by referencing my specific forms? Where do I found the subform control?

 

[PHV]

Forms!frmMyForm!SubFormControl.Form.RecordsetClone.RecordCount
And what is the problem ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886