Validation rules with IIF statements

[ckpoll2]

Hello,

I have a text box on a form where people enter numbers. How can I get it to not accept any number greater than 2 if a different text box is "Credit Hours" but to accept any number if it is anything other than "Credit Hours"?

Thanks,

Charlie

[pks00]

Hello,

I have a text box on a form where people enter numbers. How can I get it to not accept any number greater than 2 if a different text box is "Credit Hours" but to accept any number if it is anything other than "Credit Hours"?

Thanks,

Charlie

one way is to use the BeforeUpdate event of the textbox
i.e.

private sub mytxtbox_BeforeUpdate(cancel as Integer)
If Me.othertextbox = "Credit Hours" And mytxtbox.Value > 2 Then
msgbox "Sorry but value cannot be 2 if Credit Hours selected"
Cancel = True
End if
end sub

[ckpoll2]

Where would I put that information that you gave me? Does that go in the expression builder or the code builder? Can I enter it just as is?

Thanks for your help

[NeoPa]

Assuming the number TextBox is called txtNum and the other txtType then put

[txtNum]<3 or [txtType<>"Credit Hours"

into the 'Validation Rule' property of txtNum.
The 'Validation Text' property can be set to your own error message.

[ckpoll2]

That's amazing. Thanks so much for your help.

Charlie

[PEB]

for the code provides by pks00 you can put it in a form, in the respective field you want to check....

But obviously you are working with the table directly :)