AllowEdits switch 1

[andzejek]

Hi!

Is there any reason why this switch is working only once? I'm loading form with AllowEdits=false and want to switch it later as much as I need. It is switching it to AllowEdits=true just once and it is not switching it back to false. Here is the code:

Private Sub CMD_EDIT_Click()

If Me.AllowEdits = True Then
Me.CMD_EDIT.Caption = "Edit"
Me.AllowAdditions = False
Me.AllowEdits = False
Else
Me.AllowAdditions = True
Me.AllowEdits = True
Me.CMD_EDIT.Caption = "Save"
End If

End Sub

Andrew

 

[Remou]

The code works for me. Is it possible that code is running elsewhere that interferes?

 

[andzejek]

No this is only place where it is.
Is this maybe matter of Access version? I'm working with MsAccess2000.

 

[Remou]

That is the version I tested. Perhaps you could step through the code?

 

[andzejek]

yes, I did. It is just doing nothing.

 

[Remou]

Can you explain 'doing nothing' a little more? For example, is the code running at all?

 

[jkl0]

Maybe also check for
Me.DataEntry

 

[andzejek]

Thanks Remou!

"doing nothing" -> not executing command Me.AllowEdits = False. Just line abowe(ok two) I have comand switching/changing caption of the command buton to "Edit" Me.CMD_EDIT.Caption = "Edit" and thiscommand is executed and working.

Andrew

 

[Remou]

Is this a bound form? How are you determining that the code has not run?

 

[andzejek]

I placed message box before and after "Me.AllowEdits = False". Both message boxes were triggered, button changed caption from "Save" to "Edit", but I was still able to edit text in textboxes

 

[andzejek]

Yes, this is bound form.

 

[Remou]

Ok. This is quite puzzling. Pehaps it would be worth trying a scratch form with a few bound controls and the edit button with code, but nothing else.

 

[andzejek]

This same. New form is working this same way, switching to allowedits=true but not back

 

[Remou]

Could it be to do with this?

http://support.microsoft.com/kb/167420