Input Mask under various conditions

[rbinder]

Greetings,

I am a little stumped in logic again

What I am trying to do is the following

If the value is on field is say "OA" then I need an input code of LL0000 or LL00000 in the next field
If the value is say "OT" then I need an input code of LL etc

What is the best way of going about this.

The code is for stock locations in a warehouse.

~rbinder

 

[seth_belgium]

In this example:

The field that determines the inputmask is called : Field1
The field that has to receive the inputmask is called : Field2

In the "After Update"-code of Field1, place following code:

If Me.Field1.Value = "OA" Then Me.Field2.InputMask = "LL0000"
If Me.Field1.Value = "OT" Then Me.Field2.InputMask = "LL"
If Me.Field1.Value = "OZ" Then Me.Field2.InputMask = "LLL00L"

I hope you get the idea with this example, good luck!

Greetz,

Seth