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]
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.