Help needed in updating a field on a form.

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

I have a form that automatically assigns invoice numbers as records are
added. On the form is a combo box with a pull down defaulting to
"Invoice", but you are allowed to choose "Credit Memo" or "Finance Charge"
in addition to"Invoice".

What I am trying to accomplish is this. If it is an "Invoice", just the
assigned invoice number is automatically entered. If the user chooses
"Credit Memo" then in the auto number field for Invoice Number that a "CM"
be inserted in front of the invoice number. Example: CM10112 for a Credit
Memo, or 10112 for an Invoice.

Any suggestions or help would be greatly appreciated.

Thanks,

T
 
I have a form that automatically assigns invoice numbers as records are
added.
What is the method that adds the invoice number automatically? If it is an
autonumber then use another field and concatenate them for display.
 
Back
Top