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