Update checkbox when form 'Allowedits' value changes

[Moss100]

Hello I have a checkbox called CheckEditStatus

I would like this to show True when the form property AllowEdits is True (and False when False).

What event can I tie this to?

I tried the following code on the forms Current event, but no joy:

If forms!property.AllowEdits = True Then
me.CheckEditStatus = True
else
me.CheckEditStatus = False
End if

I would very much appreciate help with this (I am still trying to make the jump from Macros to code)

Regards
Mark

 

[dhookom]

What do you mean by "no joy"? What happens?

What causes the AllowEdits to change?

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

In the forms current event procedure I'd try this:
Me!CheckEditStatus = Me.AllowEdits

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Moss100]

Thanks -

Sorry for not being clear.

When I open the form it opens with allowedits = false.

Various buttons on the form make the allowedits property be set to True.

I was hoping there was some code that I could use to set the checkbox depending upon the status of the allowedits property on the form.

Thanks Mark

 

[Andrzejek]

Various buttons on the form make the allowedits property be set to True."
So wherever you have:[tt]
Me.AllowEdits = True[/tt]
add[tt]
Me!CheckEditStatus = Me.AllowEdits
[/tt]

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[Moss100]

Thanks - i'll go that way

Regards

Mark