Custom OrderNumber?

[Brook]

hello,

I am trying to create an order number that will appear on both my order
form and orderinvoice.

What I have is a combo box that the user selects the order type:
Either Custom, Program, or Sample

The ordernumbers are sequential for all ordertypes, and the format for the
order type is "0000".

What I am trying to do is this, create the invoice order number (invordnum),
so that if Custom then invordnum = "Cust - " & ordernumber, and if Program
then invordnum = "Prog - " & ordernumber, etc.

The problem I am having is that when my invordnum appears on my form is only
shows up as Cust - 1, Cust - 2, or Prog - 1, Prog - 2, and so on..

I believe there is a way to copy the format of the ordernumber to the new
field, but I cannot figure it out.


Any ideas? tips?

Thanks,

Brook

 

[Klatuu]

invordnum = "Cust- " & format(ordernumber,"00000")