Updating Field

sagsh

Registered User.
Local time
Yesterday, 21:28
Joined
Jul 18, 2004
Messages
19
Hi

I am having problem updating a field.

I have a toggle field on a form when it is pressed I want a AfterUpdate statement or a Click event to update another field. My other field is called Features which updates a field called Features in a table called UserCar.

my code is as follows:-

Private Sub Text118_AfterUpdate()
Me.Features = Me.Features & "air con"
End Sub

Private Sub Toggle115_Click()
Me.Features = Me.Features & "radio"
End Sub

When I run my form I get an error on both events as follows:-
Run time error '438':
Object does not support this property or method.

Any ideas on what I am doing wrong?
Thanks for any help

Sags
 
Is 'Me.Features' the name of the text box control or the name of the field in the underlying recordsource? Looks like you've been letting Access name your controls (by looking at the name of one your other controls; text118).

???
ken
 
I had named a field in my database and a control on my form with the same name! which was causing my problem!
Thanks for your help!

Regards
Sags :)
 

Users who are viewing this thread

Back
Top Bottom