autogenterated number on form???

  • Thread starter Thread starter anitra_tanner
  • Start date Start date
A

anitra_tanner

Hello All

I need Help!

Is there a way to autogenerate a number on a form? We have a form that
populates the orders table. O_Num(order number) has to begin with a T
or G, so that would need to be a drop-down I guess. Then they want the
next 5 digits auto-generated. I cant figure this one out
 
Sounds like you have two different things here. The T or G is an order
type? Yes, enter that in a drop-down.

The order number is an autonumber? That should be a separate field.

If you want to display the two entries together, you can do so in a separate
control on the form where an IF statement combines a T or a G with the entry
in the autonumber field.

Do a search. This type of auto-number-like key field is a pretty common
topic.
 
Back
Top