Dlookup problem

[hmho]

I have form that I enter daily sales and I have field where I have dlookup to bring the previous day's data and here are the codes.
Table name is [TblDailySales]
Form name [FrmDailySales]
=Dlookup("[Stick]","TblDailySales","[ReportDate]=[ReportDate]-1")
The problem is sometimes I'm getting the previous day's Stick and most of the time not. can someone help me what I'm doing wrong.

Thanks

 

[pbaldy]

Does this help (rev2)?

http://www.mvps.org/access/general/gen0018.htm

 

[Poppa Smurf]

You need to have the date in the correct format similar to this

=Dlookup("[Stick]","TblDailySales","[ReportDate]=#" & format([forms]![your form name]![ReportDate]-1,"mm/dd/yyyy") & "#" )