Binding variable query to field ? Possible ? (2003)

Topic

New Reply

Folks

I’d like to display a field in a form which value is the result of a SELECT count( … ) statement.

For instance I have a Parent Child table structure and I’d like to display in a form the count of the number of Child records that meet a given criteria for the current Parent record.

I have a working query taking as a parameter the Parent table primary key… but how do I bind the field to that query ? What syntax should I use ? And yes, I’d rather avoid any VBA if possible…

Thanks & regards

Alex

Reply | Quote

Replies

You could use the dcount function instead of a select statment.
Set the controlsource of the textbox to something like this :
=DCount(“*”,”tblChild”,”[IDParent] = ” & [txtParent])
This suppose you have the IDparent on your form in a textbox named txtParent

Reply | Quote

You could use the dcount function instead of a select statment.
Set the controlsource of the textbox to something like this :
=DCount(“*”,”tblChild”,”[IDParent] = ” & [txtParent])
This suppose you have the IDparent on your form in a textbox named txtParent

Reply | Quote