DCount with a subform

[Guest]

I have a main form named frmUpdateCaseEntry
I have a subform named fromCaseFeatureSubform

I want to use an unbound text box on the Main form to show the number of
records in the SUBFORM where a date field (called FeatureDateClosed) is
populated.

I tried this in my unbound field:
=DCount([FeatureDateClosed],[Forms]![frmupdatecaseentry]![fromCaseFeatureSubform].[Form],Not Null)

I also tried:
=DCount([FeatureDateClosed],[fromCaseFeatureSubform].[Form],Not Null)

Neither worked - I am getting a #Name? error. Any ideas?

 

[strive4peace]

Hi Nathan,

put the calculation in the footer of your subform

Name --> CountFeatureDateClosed
ControlSource -->
=Sum(IIF( not isnull(FeatureDateClosed),1,0 ))

you do not need this control to show -- its visible property
can be No

then, on the main form
ControlSource -->
=subform_controlname.form.CountFeatureDateClosed

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[Guest]

AWESOME! It worked! Thanks a million!

Hi Nathan,

put the calculation in the footer of your subform

Name --> CountFeatureDateClosed
ControlSource -->
=Sum(IIF( not isnull(FeatureDateClosed),1,0 ))

you do not need this control to show -- its visible property
can be No

then, on the main form
ControlSource -->
=subform_controlname.form.CountFeatureDateClosed

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

I have a main form named frmUpdateCaseEntry
I have a subform named fromCaseFeatureSubform

I want to use an unbound text box on the Main form to show the number of
records in the SUBFORM where a date field (called FeatureDateClosed) is
populated.

I tried this in my unbound field:
=DCount([FeatureDateClosed],[Forms]![frmupdatecaseentry]![fromCaseFeatureSubform].[Form],Not Null)

I also tried:
=DCount([FeatureDateClosed],[fromCaseFeatureSubform].[Form],Not Null)

Neither worked - I am getting a #Name? error. Any ideas?

 

[strive4peace]

you're welcome, Nathan happy to help


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

AWESOME! It worked! Thanks a million!

:

Hi Nathan,

put the calculation in the footer of your subform

Name --> CountFeatureDateClosed
ControlSource -->
=Sum(IIF( not isnull(FeatureDateClosed),1,0 ))

you do not need this control to show -- its visible property
can be No

then, on the main form
ControlSource -->
=subform_controlname.form.CountFeatureDateClosed

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

I have a main form named frmUpdateCaseEntry
I have a subform named fromCaseFeatureSubform

I want to use an unbound text box on the Main form to show the number of
records in the SUBFORM where a date field (called FeatureDateClosed) is
populated.

I tried this in my unbound field:
=DCount([FeatureDateClosed],[Forms]![frmupdatecaseentry]![fromCaseFeatureSubform].[Form],Not Null)

I also tried:
=DCount([FeatureDateClosed],[fromCaseFeatureSubform].[Form],Not Null)

Neither worked - I am getting a #Name? error. Any ideas?