postmanphat
Technical User
Hi,
I've had a quick look on here and online but without a great deal of luck.
I have a table that has 2 fields AutoID (autonumber) and AppID (number).
I want the AppID field in a new record to increment by 1 from the previous AppID when a new record is added.
On the form, I already have a button that the user hits to enter the date onto a new record, so any actions can be assigned to that button if that makes life a little easier?
All help is, as ever, most appreciated.
Thanks in advance.
Dave
I've had a quick look on here and online but without a great deal of luck.
I have a table that has 2 fields AutoID (autonumber) and AppID (number).
I want the AppID field in a new record to increment by 1 from the previous AppID when a new record is added.
On the form, I already have a button that the user hits to enter the date onto a new record, so any actions can be assigned to that button if that makes life a little easier?
All help is, as ever, most appreciated.
Thanks in advance.
Dave