Solved dcount query to unbound textbox

basilyos

Registered User.
Local time
Today, 08:00
Joined
Jan 13, 2014
Messages
256
hello

i have unbound form

two unbound text (txt_printed) (txt_not_printed )

i put in the control box of

Code:
txt_printed = DCount([Printed];[qry_Invoices_Printing_Data];[Printed]=True)
txt_not_printed  =DCount([Printed];[qry_Invoices_Printing_Data];[Printed]=False)

when i run the form the two textbox show #Name

any help please
 
The arguments are strings, try:

DCount("Printed";"qry_Invoices_Printing_Data";"Printed=True")
 

Users who are viewing this thread

Back
Top Bottom