DCount Criteria from Subform to Main form

  • Thread starter Thread starter Shiller
  • Start date Start date
S

Shiller

Expert,

I have an unbound text box on my Main form and I'm trying to pass
criteria to a DCount function from the subform to the unbound text
box on my main form. How do I go about doing that.

Thanks,
 
Shiller said:
I have an unbound text box on my Main form and I'm trying to pass
criteria to a DCount function from the subform to the unbound text
box on my main form.
Click to expand...


That's a little vague.

If the thing you want to pass is a number on the current
record in a subform text box and the DCount is in a main
form text box's control source expression:

=DCount("*", "sometable", "somefield=" &
subform.Form.textbox)
 
Back
Top