Error 2448 Can't set value

[Skunk]

Trying to update a checkbox on form open.

The form is bound to a table, the control is bound to a field in that table.

The control is not locked, is enabled. I see nothing that should prevent
update via the form.

I am able to update a text box, but not a check box.

I have tried me.control.value=true and me.control=true. Each throws 2448
can't set value.

When I open the table I can update as expected.

I have compacted/repaired and even rebuilt to ensure all should work. This
ckeckbox (in fact any checkbox on this form) does not.

Does anyone have an idea why not?

 

[S.Clark]

Maybe the form's Open is too soon/late. Maybe try the Form Load event
instead. If that's no good, the next step is the OnCurrent.

When all else fails, the form timer.

 

[Duane Hookom]

I think the problem is "on form open". Try move the code to the On Load event.

 

[Skunk]

Thanks to all. Timing is everything...it is now in the onLoad event and
successful.

 

[Skunk]

Got it working thanks to the others. Thanks.

How about:
Me.Control = 0
or Me.Control = -1


--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com