Help with form design

[hmho]

I'm having issues how to design this form. I have form with (Date, ProductID, ProductName, ProductPrice and LastNumebrSold) This information is enter daily. For each day I like to see the previous days data all in one form and update only the [LastNumberSold] and also enter any new product that was not in the day before and at the end I want to run report to give me the diffrent between the two day's LastNumberSold. I tried Dlookup but I'm afraid I eill mis product that was sold out before the new day's data. Any help with help. Thanks

 

[marianne]

why dont you create your form which has format properties:

default view=datasheet
views allowed=datasheet

this way you can view all your previous records in one form.

 

[hmho]

But i don't want them to change the original data

 

[ezfriend]

Add a Date field to your table and then filter the form to only show records that are >= Date - 1 . This should only give you the previous day and current date.