simple dsum function but I can't get it to work

[frdnwr]

Hello all ,


In the attached file, there is my sales table, and the form that I'd like to use as a report ..
I want to add a dsum in each control source .. that gets the sum of cash or quantities sold, based on the date range, and other criteria

I can't get the dsum to work with date range, it always returns #error

here is the syntax I'm using : =DSum("[total]","sales","[datein]=#"& forms![dailyreport]![startdate]&"#")
I am trying this after I tried the syntax for a range ..

any clue??



ps: I tried making both ends of the criteria a short-date, I tried making the row source of the start date field values from " select distinct ... " query
I still get #error

[ranman256]

If forms![dailyreport]![startdate] has no date in the text box you'll get an error.

MAKE SURE there is a value. If this happens at ON LOAD event, it could resolve before the txt box gets a value.

[frdnwr]

I did ...

I still get the #error ...

[frdnwr]

so, what else may cause this error?
or how can I use an alternative method .. a query maybe

[frdnwr]

I added the code to a button, to set the control source of each field to the dsum function of the related sum .. and it worked fine.