Richard, do you have any videos related to what I'm trying to get accomplished below.  It might not be the simplest way but currently I am trying some things with this using If Then statements.  An easy or easier solution is probably staring me right in the face but I'm over thinking it.  I have all your Access videos except for the recordset ones.  Plus I've taken your first two Visual Basic courses.  If you cover something in any of these that can help then please direct me there.  I started taking your courses about 6 years ago to help me with building an inventory database where I work, which I currently have one in place.  Thank you for that!  I probably need to go back and review them all again because when working on trying to get a solution for this I realized I had forgotten some basic things.  Hence the need to be pointed in the right direction.
I have a main form from which I can select a product and it will pull up just that product item and its information.  On the pulled up form I have five text boxes for entering dates when an item comes in.  We never get more than two- three items in at a time of any product we carry so hence the need for only five text boxes.  Once we get down to two left of a particular product I have a way it lets me know and I order more.  These text boxes are stacked on top of each other with the oldest dated item on top and the next oldest in the box below and so on down the line with the remaining boxes.
What I need is a way when the oldest item is taken out of inventory and deleted (the oldest dated item, which would be listed in the top box and would be the one deleted) that once it is taken out, the next oldest item moves up to the text box above it and all sequential ones below follow suite.  Currently I manually have to move them up the line and we have close to 500 products and growing so you can imagine.
Example below of what the dates look like in text boxes.
10/17/2012
11/2/2012
11/24/2012
12/5/2012
12/12/2012
While trying (still am) the If Then statements I named the text boxes Box1, Box2, etc.
As already mentioned say that the top one is deleted/pulled out of stock.   I manually go in and move the ones below it up a box so that I can put the newest product that has come in at the bottom.  I know that I can just delete the oldest one no matter where it's located and then enter the next one in that spot but it just looks more professional with them being in dated order.
Like I mentioned at the start, if you have a video or videos out that would point me in the right direction then please let me know.  
Thanks in advance!
I'm sure somebody else out there has come across this situation before so if you have let me know what your solution was.

---

Reply from Richard Rost:

Well, the first thing I'm going to say is that you shouldn't be using 5 static text boxes. You should be either using a LIST BOX or a SUBFORM so you aren't limited to 5 items.

BUT... if you want to keep with your current setup, I'm assuming you're using DLOOKUP or some other means to fill these boxes in? You would then either need to use a recordset or some SQL commands to update the values when you clear the top item.

You could do it with a series of UPDATE SQL commands, set 5 to 4, 4 to 3, 3 to 2, 2 to 1, and then blank 1.

Am I on the right track?