Using Select Case to evaulate a new field entry

Just move the code you wrote under the button to a
function that you create under the form.
on the event after update of each of your field call that
function.
Also call the function on the load of your form.

>-----Original Message-----
>I wish to use select case to evaluate a rating based on
the values of two
>other fields and then display this in a fild on a form. I
have managed to get
>it work by using a command button, but I would like the
new field to update
>automatically update after changes to the base fields.
>.
>
.