Ok, so on a form I have I'd like to have a field labeled Last: {} with the {} containing the last number entered in a field in a table. Then the user could verify they were entering the correct next number. I can't autonumber these because based on a variety of different parameters, not every record gets a number. I have 7 fields I'd like to do this for.
For example, the user needs to enter a number in a field called IA_Number. I'd like them to be able to see what the last number entered was before they enter the next number.
Any ideas?