Option button is locked

A

Ann

I have a form with an "on timer" event.

I would like to have an option button "AutoUpdate" that
when checked skips the on timer event - so I have made a
statement in the event procedure:

If Me.AutoUpdate Then
...
logic
...
End If

For some reason my option button control is locked? Why is
that? (and it is both "enabled" and "not locked")

When I place a similar control on a new form it works
fine... What's wrong?
 
B

Bruce

I see that nobody has responded yet, so I'll weigh in. Acutally, I have
mostly questions: What is the On Timer event? If it is an option button,
what are the other options? Or is it a checkbox? You mention a "statement
in the event procedure". What event, and for which object or control.
Your If statement leads nowhere, as nearly as I can tell. Something like:
If Me.Autoupdate = -1 Then
Condition 1
Else: Condition 2
End If

in the after update event for autoupdate could get you somewhere if it is a
Yes/No field, but if it is an unbound control used only for skipping the
timer event you would need a different approach.
Going to need some more information here.
 
Top