Using Select Case to evaulate a new field entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top