How to show information for a previous record on a current form

[betmck]

Access 2000:
I have 8 salesmen selling the same 10 items. I also have a sales table with each record showing: (date, salesman) - and for each item (opening stock, sales, closingstock, qtyreturned).

To open the daily sales form I first select the date and then the salesman. I have to key in figures for Opening stock, sales and qtyreturned(this could be different from closingstock), closing stock is calculated.

What I want is after I select the date and salesman and the form opens, the qtyreturned for each item from the previous day becomes the opening stock for each item for the date selected for that salesman.

 

[SeaRox]

Someone else could probably help you better with the exact code but if you put some code in the "Default Value" you can have it look up the value you want (maybe with DLookUp function) using the Date function (Date-1) as a criteria.