J
jrowland
Trying to understand how a autonumber field works.
Currently have 1 table, with two fields:
Field Name Type
Doc_no autonumber
due_dt date (defined as being required,
cannot be blank or null)
Have designed a simple form with navigational buttons for Next,
Previous, First Record,
Last Record, Add Record, Save and Undo.
Currently the autonumber field is set at 100.
1. User clicks on the Add Record Button
2. All fields are cleared out except the Doc_no field. It shows
(Auto Number) in the field.
3. User adds a date in the due_dt field
3a. autonumber field increments to 101
4. User clicks the Undo button to abort adding a record
5. Next time user goes to add a record, the autonumber field incremented to
102
Couple of questions.
1. From what I can tell, when record pointer is at the last record in the
table and you click on the "NEXT" button, seems to going into the "Add Record
Mode" automatically. Is there any way to stop this.
2. Clicking the Undo record button does not abort the "add routine". A
record is added even though the due_dt field is set to being "Required"
Is there any way to stop the autonumber field being incremented if user
aborts out of the ADD process?
I am using the button wizards to add all my buttons
Thank You for your input.
Jeff
Currently have 1 table, with two fields:
Field Name Type
Doc_no autonumber
due_dt date (defined as being required,
cannot be blank or null)
Have designed a simple form with navigational buttons for Next,
Previous, First Record,
Last Record, Add Record, Save and Undo.
Currently the autonumber field is set at 100.
1. User clicks on the Add Record Button
2. All fields are cleared out except the Doc_no field. It shows
(Auto Number) in the field.
3. User adds a date in the due_dt field
3a. autonumber field increments to 101
4. User clicks the Undo button to abort adding a record
5. Next time user goes to add a record, the autonumber field incremented to
102
Couple of questions.
1. From what I can tell, when record pointer is at the last record in the
table and you click on the "NEXT" button, seems to going into the "Add Record
Mode" automatically. Is there any way to stop this.
2. Clicking the Undo record button does not abort the "add routine". A
record is added even though the due_dt field is set to being "Required"
Is there any way to stop the autonumber field being incremented if user
aborts out of the ADD process?
I am using the button wizards to add all my buttons
Thank You for your input.
Jeff