Select Case On Command

[Randomblink]

I have tried everything and am going crazy now...
I have created a form where users pull up various City Projects...There are 2 types of Projects, City and Contract...The field that stores the Type of Contract is named [PSRTYPE] and I am trying to call certain Subs whenever a user pulls up one or the other type...I have created a Sub that runs a select case per the [PSRTYPE] field, and I have tried calling it at every point where the [PSRTYPE] field would change...Instead, it will hold the last value used during the Select Case instead of the new one...What am I doing wrong...?

I guess the biggest question is, where would I run the Select Case so that it ran EVERYTIME the field [PSRTYPE] changed...? Is there an event or way of writing the code so that it runs in the background...? HELP!

 

[charityg]

If you're using a form to change the [PSRTYPE] field, it would make sense to run your procedure from the afterupdate event of that field.

 

[Randomblink]

And that is what I did...
But I was considering having another field update the [PSRTYPE] field, and then it won't recognize the afterupdate (if done from VB) so I was trying to find another solution...
I went ahead and did it like you said, that was my original experiment, and I left it so that they have to select from that field...
Ah well...