What i need is.....
A textbox to show what number the next record in a table is going to be.
I have a column called "Series". This works like cars or a television series. There is series 1, 2, 3 & so on. What i would like a textbox on a form to do is show me the current series and what number the next in series would be. Is this possible?