Record Count

[Shiller]

Experts,

I'm trying to dynamically stored the record count from a subform into
a field on my form. Now I have to look at the record count on the
subform and manually entered the count into a field on form. There
must be a better way.

Please help!

 

[Guest]

In the Control Source property of a text box on the main form:
=[SubFormControlName].[Form].[recordset].[RecordCount]

Where SubFormControlName is the name of the subform control, Not the name of
the form that is the Source Object of the subform control.

 

[Shiller]

In the Control Source property of a text box on the main form:
=[SubFormControlName].[Form].[recordset].[RecordCount]

Where SubFormControlName is the name of the subform control, Not the name of
the form that is the Source Object of the subform control.
--
Dave Hargis, Microsoft Access MVP

Experts,

I'm trying to dynamically stored the record count from a subform into
a field on my form. Now I have to look at the record count on the
subform and manually entered the count into a field on form. There
must be a better way.

Please help!

Hello Dave,

I tried that and I keep getting the following error message: #Name?

Thanks,

 

[Guest]

Okay there is a naming problem. I know this works, I tested it before I
posted it.
Do you understand the difference between a subform control and form that is
the Source Object of the subform control?
That is the important part.
What you see in the subform control is the form being used as a subform.
It's name is not important. You have to use the name of the control.

--
Dave Hargis, Microsoft Access MVP

In the Control Source property of a text box on the main form:
=[SubFormControlName].[Form].[recordset].[RecordCount]

Where SubFormControlName is the name of the subform control, Not the name of
the form that is the Source Object of the subform control.
--
Dave Hargis, Microsoft Access MVP

Experts,

I'm trying to dynamically stored the record count from a subform into
a field on my form. Now I have to look at the record count on the
subform and manually entered the count into a field on form. There
must be a better way.

Please help!

Hello Dave,

I tried that and I keep getting the following error message: #Name?

Thanks,

 

[Shiller]

Okay there is a naming problem. I know this works, I tested it before I
posted it.
Do you understand the difference between a subform control and form that is
the Source Object of the subform control?
That is the important part.
What you see in the subform control is the form being used as a subform.
It's name is not important. You have to use the name of the control.

--
Dave Hargis, Microsoft Access MVP

In the Control Source property of a text box on the main form:
=[SubFormControlName].[Form].[recordset].[RecordCount]
Where SubFormControlName is the name of the subform control, Not the name of
the form that is the Source Object of the subform control.
--
Dave Hargis, Microsoft Access MVP
:
Experts,
I'm trying to dynamically stored the record count from a subform into
a field on my form. Now I have to look at the record count on the
subform and manually entered the count into a field on form. There
must be a better way.
Please help!

Hello Dave,

I tried that and I keep getting the following error message: #Name?

Thanks,

Dave,

it works like a charm, now the record count is displayed on my form.

Thanks,

 

[Guest]

Crashes my DB every time I try to open the form this is on.

In the Control Source property of a text box on the main form:
=[SubFormControlName].[Form].[recordset].[RecordCount]

Where SubFormControlName is the name of the subform control, Not the name of
the form that is the Source Object of the subform control.
--
Dave Hargis, Microsoft Access MVP

Experts,

I'm trying to dynamically stored the record count from a subform into
a field on my form. Now I have to look at the record count on the
subform and manually entered the count into a field on form. There
must be a better way.

Please help!