newbie, trying to set field using vba edior. help please 1

[20fva]

this is the code i am using to test:
(redline is higlighted in debugging due to Error 13 Type Mismatch)

Dim myField As Field
Set myField = Me.ComboRel2
If IsNull(myField) = False Then
MsgBox Str(myField)
End If

any thoughts?

Reason for this:
i have 10 fields and a lengthy after_update function assigned to each. I wanted to write a function that and use variables (including the field) so that my application is more Object Oriented.

Not Urgent. Thankyou all.

---------
Claudia

 

[AccessAce]

Here may be the trouble.

ComboRel2 is not a field. It is actually a control linked to a field. Therefore, I think what you want is more like this:

Dim myField As Control
Set myField = Me.ComboRel2

 

[20fva]

Wow. Quick response time. Thankyou so much for being helpful.

I figured it was something simple.

You really are an Ace.

--------
Claudia