add new recored but keep same customer ID

  • Thread starter Thread starter Simon
  • Start date Start date
S

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
 
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
 
Simon said:
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
Click to expand...
 
Back
Top