Recent content by dbonin1599

I don't understand what the me.control does...I am working with MS Access and would like to use this code snippet, but I don't quite understand it. I get most of it, but I don't get the me.control and I don't understand how it knows what field to look at? Also, if I put this in as a SUB or a...

Thanks Leigh, ajetrumpet and HiTechCoach You are the reason this sight is so much fun to visit. Happy Holidays from Minnesota! :cool:

Switch would be a more common function choice for Jet in your position - AFAICR it is a shared function and so would work with Jet even from data access external to Access. That aside, the substitution table as Boyd mentions is the best bet anyway. Cheers. My main issue here is I want to...

Thanks so much. I actually went back and tried the IIF statements since there are not a lot of variables rather just a lot of records that need updating. This worked great. One note though, I wasn't sure how the last if statements FALSE (see below) should be handled. I finally used the field...

I am trying to figure out how to update a field in my database based on varying criteria. For instant, if field is currently "Tree" I want to set it to "OAK", but if it is currently "Leaf" I want it set to "Maple" SO in my code I have this so far, but, of course:mad:, it is not working or I...