Adding a new record
I have a continuous form with a command button in the form header to add a new record. As there are already many records that have been entered, the new record appears at the top of the form with no previous records visible. How can I modify the code so that at least 5 or 6 previous records are visible. I tried using code to go to the last record, then to the previous record several times before going to a new record and that works as long as there are previous records to go to but in the beginning when there are no previous records to go to, an error message repeats "You can't go to the specified record" even with Set Warnings turned to false.
|