I need to create an IIf function.

I have a field called "BREED". There are only two types that can go in this
field, either "Siamese" or "OSH". In the next field (Eye Colour) I want to
enter the eye colour depending on the Breed automatically. If it is Siamese
then the result I want under eye colour is "Blue" and if it is OSH then I
want the eye colour to enter Green automatically. Is this possible? Is the
IIF function the correct one to use, if so, what the heck is the code!!!!!

thanks
Julie

[posted and mailed]

"Julie Nicole" <julie.holmes (AT) quicksilver (DOT) net.nz> wrote in
news:1090385638.657023 (AT) drone1-svc-skyt (DOT) qsi.net.nz:

In the field "OSH", you could use IIf in a query like this:

Eye Color: IIf([BREED]="OSH","Green","Blue")

The SQL for that would look like this:

SELECT Table.BREED, IIf([BREED]="OSH","Green","Blue") AS [Eye Color]
FROM Table;

It's important to note that this assumes you will never, ever have
another breed other than Siamese or OSH, though, because you won't be
able to enter an eye color for them through this query.

HTH,

Mike

"Julie Nicole" <julie.holmes (AT) quicksilver (DOT) net.nz> wrote

Hello Julie,

What you could do is enter the following code into the
"After Update" property of your field:

If Breed.value = "Siamese" Then
EyeColour.value = "Blue"
DoCmd.GoToControl "EyeColour"
ElseIf Breed.value = "OSH" Then
EyeColour.value = "Green"
DoCmd.GoToControl "EyeColour"
Else
MsgBox "Please enter the correct Breed type!", vbCritical, "Enter Correct Breed"
End If

You wouldn't need to use an IIF funtion anywhere. Just
remember to put the above code into the correct
location.

Regards,

Ray