Solved dcount query to unbound textbox

[basilyos]

hello

i have unbound form

two unbound text (txt_printed) (txt_not_printed )

i put in the control box of

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]

The arguments are strings, try:

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

 

[basilyos]

The arguments are strings, try:

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

Bossssss. big thanks

 

[pbaldy]

Happy to help!