Automatically setting a value

[Guest]

Good day,

I am currently attempting to set one field's value depending on the value of
another vield.

Ie.

I would like the database to automatically determine how many vacation days
a person has depending on their contract.


15 to 29 days = 1 day vacation
30 to 44 days = 2 day vacation
etc...

it would be nice to have the computer generate this number based upon their
contact length rather then entering it manually.

Many Thanks

 

[Chriske911]

Good day,

I am currently attempting to set one field's value depending on the value of
another vield.

Ie.

I would like the database to automatically determine how many vacation days
a person has depending on their contract.

15 to 29 days = 1 day vacation
30 to 44 days = 2 day vacation
etc...

it would be nice to have the computer generate this number based upon their
contact length rather then entering it manually.

Many Thanks

some sub you want to trigger_event()
select case 1st_field.value

case between 0 and 14
2nd_field.value = 0
case between 15 and 29
2nd_field.value = 1
case...
case else
msgbox "bad luck", vbokonly, "ooooohhhhh....."

end select
end sub

grtz