This *should* be easy, but I can't figure it out: I need to store values from textbox(es) into a temporary space so that I can recall the number after adding a new record. For instance, I have Purchase Orders and a details form underneath it. Once I hit Add Record, the current PO number disappears. I also want to be able to do some basic math for the Item Number textbox. So, if the PO # is 20002 and the last item is 4, I want to be able to hit new record and recall the PO # (20002) as well as add 1 to the item box (to make it 5, in this case). Thoughts? For the counter, I've tried this:

dim i as integer
i = txtItemNo.text

if i <> 0 then
i = i + 1
i = 1
end if
The only problem is that I don't know exactly where to stick this. If I put it in Add_Record.OnClick, then it will (obviously) pull a zero, since the new record was created. I just need to be able to house these numbers temporarily so that I can recall them.