Populating Auotmatic Number

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

When opening a form I need a new number to populate each time the form is
opened and data submitted. Below is my example:

I open the form. Tracking Number populates at the top of the form "00001".
I enter Program and Order # associated with that Tracking Number. All three
fields are submitted together. Close form

The next user opens the form and The Tracking Number should populate with
"00002". User enters Program and Order # and it also submits the three
fields together.

The next person opens the form it reads "Tracking Number 000003". They
close the form without adding Program and Order #.

The next person opens the form and it reads "Tracking Number 000003" again
since no Program and Order # was submitted with "000003" from previous user.

Thank you!
 
Open up your table in design view, is your TrackingNumber field set to
AutoNumber?
 
Yes it is. On the form it just says (Auto Number) in the text box. How do I
get it to compute a number?
Open up your table in design view, is your TrackingNumber field set to
AutoNumber?
When opening a form I need a new number to populate each time the form is
opened and data submitted. Below is my example:
Click to expand...
[quoted text clipped - 17 lines]
Thank you!
Click to expand...
Click to expand...
 
Back
Top