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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a Recored to a form 3
append query 5
Adding delivery adddress 1
Looking up mulitiples items 1
Order Number 2
tick all boxs on contiuoiuse form 1
Customer look UP 2
adding a date 2

Back
Top