Restrict Data Entry

[BillySpivy]

Hello,

Is there a way to restrict data entry on a form to 1 of 3 formats?

P-123456
W-123456


AFR-12345

Whereas if it's a purchase order it will be: "P-" followed by the number
If it's a work order it will be: "W-" followed by the number
If it's from a repair it will be: "AFR-" followed by the number

Thank you for any help

[aytee111]

You may want to consider three separate subforms, making them visible/invisible depending on the entry.

[BillySpivy]

This entry is a column on a subform for parts used for the repair indicating where the part came from for tractability. The users sometimes but many spaces or lower case letters or just about any way they feel like. So it's difficult to keep things in order is why I asked.

[aytee111]

Oh!

Create an option group field, for one of the three types. Then add the prefix to the number they enter using VBA.

[BillySpivy]

Okay that sounds reasonable but how to do?

[aytee111]

In the AfterUpdate event of the number field:
If Me!frame_field_name=1 Then
Me!concat_field_name="P-" & Me!number_field_name
ElseIf Me!frame_field_name=2 Then
...etc

[BillySpivy]

Thanks for the suggestion but I will edit the data as needed. It seems too complicated for me.