I have a form that displays two text boxes; the first(txtEntry) is blank and is for user input and the second(txtPrevious) is supposed to show the previous record (it is the basis for an error-checking routine: txtEntry must be > txtPrevious). My problem is: how do I get the contents of txtPrevious into txtEntry when the previous record button is clicked? I am using the Last function for txtPrevious ControlSource, but when the user attempts to edit the record by clicking the previous record selector, the last entry remains in txtPrevious. I know the Last function is inappropriate, but I don't know what to do!
txtEntry txtPrevious
10
20 10
30 20
37 30
45 37
51 45
txtEntry txtPrevious
10
20 10
30 20
37 30
45 37
51 45
