autogenterated number on form???

[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

 

[Rick B]

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.