B
Bradley
The autonumber field does not update immediately upon
entering data into a field. For instance, I can enter
part of a Date in a date field or enter Letters into a
combo box to select a customer, but the autonumber field
wont update like it does on other forms.
The query behaves the same way as the form.
---<<<< Steps to Reproduce this behavior >>>>---
--- Reproduce in a Query ---
Using the Northwind database examine the "Orders Qry"
Click into the Customer ID when the query is running
and enter text. You will notice that the Autonumber
field is blank for the new record.
If you select a customer from the drop down or if you
tab out with a valid selection the autonumber field will
update.
However, if you press cancel that record will not be
written and the autonumber will NOT be used.
My question is why does it not write the autonumber
immediately apon entering text in query mode? Why is it
that when in the "Orders" forms it WILL use an Autonumber
immediately apon entering text (see below to reproduce)?
Reason why I ask is I have a form that will not
immediately use an Autonumber, while my other forms do!
--- Reproduce in form view---
Open the form "Orders" in design view and add the
field "OrderID" to the form. When you add a new record
you will notice that the form will use an Autonumber
immediately apon entering text.
entering data into a field. For instance, I can enter
part of a Date in a date field or enter Letters into a
combo box to select a customer, but the autonumber field
wont update like it does on other forms.
The query behaves the same way as the form.
---<<<< Steps to Reproduce this behavior >>>>---
--- Reproduce in a Query ---
Using the Northwind database examine the "Orders Qry"
Click into the Customer ID when the query is running
and enter text. You will notice that the Autonumber
field is blank for the new record.
If you select a customer from the drop down or if you
tab out with a valid selection the autonumber field will
update.
However, if you press cancel that record will not be
written and the autonumber will NOT be used.
My question is why does it not write the autonumber
immediately apon entering text in query mode? Why is it
that when in the "Orders" forms it WILL use an Autonumber
immediately apon entering text (see below to reproduce)?
Reason why I ask is I have a form that will not
immediately use an Autonumber, while my other forms do!
--- Reproduce in form view---
Open the form "Orders" in design view and add the
field "OrderID" to the form. When you add a new record
you will notice that the form will use an Autonumber
immediately apon entering text.