Orders Form / Mutiple Order Types

[Brook]

Good day,

What I have is this: tblorders (which houses all my orders - Custom (CST),
Stock (STK), and Sample (SPL). within the tblorders I have an "orderstype"
and "ordernumber".

What I am trying to do is this: create either a Combo box or an option
group on my form, so that when I choose the appropriate order type, that type
code is saved in the "ordertype" field in my table, and the "ordernumber" for
that type is increased / incremented by 1.

Any Ideas / suggestions?

thanks,

Brook