asked on
DCount in Bound Field
I am having trouble using DCount in a bound text field. Is this possible? I can use the following syntax to get the result in an unbound control in a query, but would like to place the results in a bound field in a table. Thanks.
Sets: DCount("SetsRepID","tblSet
Sets: DCount("SetsRepID","tblSet
Microsoft Access
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
<<I am having trouble using DCount in a bound text field. Is this possible?>>
No it's not possible. You'll need to set the control (or field that the control is bound to) in code from somewhere else.
JimD.
No it's not possible. You'll need to set the control (or field that the control is bound to) in code from somewhere else.
JimD.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Got it, thanks.
You are welcome ...
mx
mx
You mean on a Form ?
You can do this ... set the Control Source of an *unbound* Text box to:
=DCount("SetsRepID","tblSe
Not completely sure what you mean ...
mx