Select Case Problem 1

[rookiedev]

I have had great success with the Select Case information provided by the experts here, however I have run into a snag when I try to change a combo box that uses a value list. I typed it in as such:
Select Case Me.PaymentMethodID
Case Is = "22"
Me.TAG ="VAC"
Me.LCode = "02"
Me.Note = "$27.29"
Case Is = "24" etc................
Everything works wonderfully except for the field named "TAG" it has a default value of "Regular Hours" and it does not change....no matter what I do.

I'm at my witts-end with why it wouldn't work and all the other fields will update. Of course this is probably the most important field to be updated too.

Can anyone offer any help here?? is there anything that would stop a combobox from being updatable? I do not have limit to list selected

Please Help!!!
[Sadeyes]RookieDev

 

[chrissie1]

it is possible that tag is a resevered word

try this

me.[tag] "What a wonderfull world" - Louis armstrong

 

[nat1967]

Hi rookiedev,

My guess is that you are working with a reserved word in Access. TAG is a property that is found on the "Other" tab in the properties window.

You have two choices. Either change the name of your object to a non reserved word such as txtTag or Tag1 etc...

or

you can try using the bang instead of the period.

Me!Tag

The bang (!) tells Access you are calling an object and not a property.

Try this and let me know if it doesnt help. Have A Great Day!!!,

Nathan
Senior Test Lead

 

[rookiedev]

HI NATHAN1967!
You are so correct!!! I didn't realize that TAG was a reserved word. I changed my field name to Type and everything worked great! The bang (!) doesn't work nor does Chrissie1's suggestion of using []'s, just for future reference.There is not much else that can be done other than changing the field name. This star's for you!!!!!

Thanks So Much,
RookieDev

 

[nat1967]

Glad I could help. Have A Great Day!!!,

Nathan
Senior Test Lead