add new recored but keep same customer ID

[Simon]

I have a order form that shows customers order, i would like to add a
button to this form that will let me add a new recored and also set
the Customer Number automtical

On the current form there is a field txtCustomerID. When i add a
button with the code DoCmd.GoToRecord , , acNewRec i would lile the
txtCustomer ID Number to apear in the new recored

Any way of doing this

 

[Tom van Stiphout]

On Sun, 28 Jun 2009 03:06:35 -0700 (PDT), Simon <[email protected]>
wrote:

In the table design, make CustomerID an Autonumber.
Then when you go to a new record AND TYPE THE FIRST CHARACTER IN SOME
FIELD the Autonumber will display automatically.
Typically Autonumbers are used for behind-the-scenes processing and
not shown on forms.

-Tom.
Microsoft Access MVP

 

[o;;]

I have a order form that shows customers order, i would like to add a
button to this form that will let me add a new recored and also set
the Customer Number automtical

On the current form there is a field txtCustomerID. When i add a
button with the code DoCmd.GoToRecord , , acNewRec i would lile the
txtCustomer ID Number to apear in the new recored

Any way of doing this