Using Select Case to evaulate a new field entry

[Guest]

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.

 

[Ofer]

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.