DCount Criteria from Subform to Main form

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,
 
M

Marshall Barton

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.


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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top