Designing a simple DB that can enter cheque details we receive in the post.
Ive set up a table with the following headings
ID (primary key)
Cheque no
Amount
Name on cheque
Policy number
I then set up a form to input all the above data which works fine.
However if you close access then go back in and go into the form it starts at no.1 and not a blank one to enter the next cheque into.
Im sure its something really simple but cant seem to find it.
Thanks for any help
Ive set up a table with the following headings
ID (primary key)
Cheque no
Amount
Name on cheque
Policy number
I then set up a form to input all the above data which works fine.
However if you close access then go back in and go into the form it starts at no.1 and not a blank one to enter the next cheque into.
Im sure its something really simple but cant seem to find it.
Thanks for any help