I have 8 salesmen selling the same 10 items. I also have a sales table with each record showing: (date, salesman,also each item's - opening stock, sales, closingstock and qtyreturned). To open the daily sales form I first select the date and then the salesman. I am keying 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, when the form opens, the qtyreturned for each item from the last working day for that salesman becomes the opening stock for each item for that same salesman. Help needed please

What you have is a homework problem. What you want is someone to answer it for you. What that's called is cheating!

Hi Cuffy: Thanks for your response. However, I find this comment out of order and disrespectful. I am assuming that you did not quite understand the scenario I posed, so I forgive you

Well, your question does read exactly like a homework question. That being said, you may have to get into VB programming with a date function or some how have your database open from a query that updates query or forms upon opening. Coming home from very lonely places, all of us go a little mad: whether from great personal success, or just an all-night drive, we are the sole survivors of a world no one else has ever seen. -