prefix formatting for an Auto number field 1

[justagrunt]

Hi,
Is it possible to automate the selection of a prefix for an Auto numbering field.
On the form the text box format is >"BO" which does nicely and adds a prefix to create 'BO6953" etc and this appears in the table.
If I have say 6 prefixes that are required, can the choice be automated to allow selection of one of these prefixes to alter the field format and set it for that moment?
So that each time the form opens a prefix selection is required which sets the text box format for the autonumber field.
If so - How???????
Any pointers and suggestions appreciated.
Warm Regards
Bill

 

[Zion7]

I imagine, in the appropriate event;

Form_Before/AfterInsert()
SElect case ....
Case 5: Me.pkId.Format = ">BO"
Case 6: Me.pkId.Format = ">FO"
Case 3: Me.pkId.Format = ">BR"
End Select



Form_Current
If Me.NewRecord = True Then
SElect case ....
Case 5: Me.pkId.Format = ">BO"
Case 6: Me.pkId.Format = ">FO"
Case 3: Me.pkId.Format = ">BR"
End Select
End If

 

[justagrunt]

Cheers.
Great thanks.
Beaut.
And all other ways to say thanks.
Warm Regards
Bill