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
Thanks,
SWK
txtEntry txtPrevious
10
20 10
30 20
37 30
45 37
51 45
Thanks,
SWK