Error 438 error in Access 97

[Bones]

I am relatively new at Access code but having an issue with this. I have an 'event' code on each of 2 different checkbox fields that is working just fine. PreferredArea is a text field. The code is as follows:

Private Sub AreaCalc()
Me![PreferredArea] = " "

If Me![Oregon] Then
Me![PreferredArea] = "Oregon"
End If

If Me![Washington] Then
Me![PreferredArea] = Me![PreferredArea] & ",Washington"
End If

End Sub



The following code should do the same thing on 3 different check box fields. All I want is for the 3 underlying fields (if checked) to add the text to the [Type] field. The field [Type] is also a text field.

Private Sub TypeCalc()
Me![Type] = " "

If Me![TypeHouse] Then
Me![Type] = "House"
End If

If Me![TypeCondo] Then
Me![Type] = Me![Type] & ",Condo,Plex"
End If

If Me![TypeApartment] Then
Me![Type] = Me![Type] & ",Apartment"
End If

End Sub


I get the following error message:

Object doesn't support this property or method (Error 438) .

Not sure why this isn't working.

Bones

[RuralGuy]

1st, Type is a Reserved word and should be avoided. http://www.allenbrowne.com/AppIssueBadWord.html#T
2nd, You probably have a Control by the same name. Access can easily get confused as to which target you are referring.
3rd, I would change the name of the field to something like MyType and also the name of the Control to txtMyType. No ambiguity or conflict.

[Bones]

Thank you sooooo much. That was the problem! Why haven't I found this site (you) sooner. I have been struggling now for a month or so with different issues looking on the internet whenever I am stuck. I semi-retired about 5 years ago or so, and am not activitely working in Access any longer. The DB was built by someone else originally. The company brought me back to do some this special project and work in the old Access 97 DB. I may have some other issues I can't resolve and will post again.
Again, thank you so much!!

[RuralGuy]

Excellent! Glad we were able to help. Go ahead and use the Thread tool and mark this thread as Solved.