Solved dcount query to unbound textbox (1 Viewer)

basilyos

Registered User.
Local time
Today, 05:00
Joined
Jan 13, 2014
Messages
252
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
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 05:00
Joined
Aug 30, 2003
Messages
36,118
The arguments are strings, try:

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

basilyos

Registered User.
Local time
Today, 05:00
Joined
Jan 13, 2014
Messages
252
The arguments are strings, try:

DCount("Printed";"qry_Invoices_Printing_Data";"Printed=True")
Bossssss. big thanks
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 05:00
Joined
Aug 30, 2003
Messages
36,118
Happy to help!
 

Users who are viewing this thread

Top Bottom