I got a problem with the command button - next record in the form.
The form is basically viewd by Register ID which is auto number. The problem is when I press the next record button, the auto number keeps goes up. But I would like it stops in the last record I've entered. For example, the last record is no.3205, but when I keep press the next record button, the register ID also goes up to 3206, 3207, 3208, etc. Is there any way to do?
any help would be greatly appreciated.