Validation Help Needed

[msmit8]

I need help adding some validation to my accessdatabase.

Line_of_Business field list contains:
·AUDIT
·COMMERCIAL LINES
·PERSONAL LINES
·CLAIMS DEDUCTIBLE

Policy_Account_Number field is the field Iwould like to add validation to.
·If Line_of_Business = AUDIT, I would like thefield to only contain alpha and numeric text. Example = 48X12345-01-00 Set 0001
·If Line_of_Business = COMMERCIAL LINES, I wouldlike the field to only contain alpha and numeric text. Example = 000-000-000-00
·If Line_of_Business = PERSONAL LINES, I wouldlike the field to only contain alpha and numeric text. Example = 000-000-000-00
·If Line_of_Business = CLAIMS DEDUCTIBLE, Iwould like the field to only contain alpha and numeric text. Example = 00-000-000000



Any help or tips in doing this would be greatlyappreciated.

Thank you!

[June7]

What a pain - changing account number structure based on type of account!

Could use code to change the InputMask property. Code would be needed in the form Current event as well as the Line_of_Business combobox AfterUpdate.

[msmit8]

Thanks for your reply. I'm by no means a "code writer". Do you have any suggestions in for what I need to include in the code for this? If possible, could you provide me some examples for each place you mention I need to insert code?

Thanks again!

[June7]

Something like:

Sub Line_Of_Business_AfterUpdate()
Call SetMask
End Sub

Sub Form_Current()
Call SetMask
End Sub

Sub SetMask()
Select Case Line_Of_Business
    Case "Audit"
        strMask = "000\-00000\-00\-00;0;_"
    Case "Commercial Lines", "Personal Lines"
        strMask = "000\-000\-000\-00;0;_"
    Case "Claims Deductible"
        strMask = "00\-00\-000000;0;_"
End Select
Me.Policy_Account_Number.InputMask = strMask
End Sub

[msmit8]

Thanks for providing me the code and my apologies for the late response. I made some changes to my database that will require new code...I think.

I have 5 different boxes that the entry user would select that would depend on the type.



The users will enter the policy type in the "Account_Policy_Number" field. Can you help me with the code that I should use for the validation with this.

·If Claims_Deductible is selected, I would like the Account_Policy_Number field to only contain alpha and numeric text. Example = 00-000-000000
·If Ledger_Audit is selected, I would like the Account_Policy_Number field to only contain alpha and numeric text. Example = 48X12345
·If Phoenix_Audit is selected, I would like the Account_Policy_Number field to only contain alpha and numeric text. Example = 48X12345-01-00 Set 0001
·If CL_EP or PL_EP is selected,, I would like the Account_Policy_Number field to only contain alpha and numeric text. Example = 000-000-000-00

Thanks in advance!

[June7]

Adapt the code example as needed. Post your attempt for analysis if you still have issue.

[msmit8]

Here is the code I entered:


When I try and save it, I get this message.


Any advice to get this to work would be greatly appreciated.

Thanks greatly!

[June7]

It doesn't make sense to set the input mask based on the Policy_Account_Number. Shouldn't it be Line_Of_Business determines structure of the account number mask?