AllowEdits=False issue

  • Thread starter Thread starter Maver1ck666
  • Start date Start date
M

Maver1ck666

I have a main form which pulls down data based on the form it was open from.

What I want it to do is to look at a field it has just updated, and
depending on its result, either make AllowEdits = false or true (and a couple
of others).

I used the code:

If [Forms]![Frm UserViewBreach]![Str_Status] = "Rejected" Then

Me.AllowEdits = True
Me.AllowAdditions = True
Me.AllowDeletions = True
CmdSubmit.Enabled = True

Else

Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowAdditions = False
CmdSubmit.Enabled = False

End If

Now it runs through the code but I can can still make changes etc on the form.

What am I missing please?
 
Thanks for the reply.

Im not sure though how this will work and it doesn't seem applicable to A03.

BeWyched said:
Hi

This give you the answer/solution:

http://kbalertz.com/167420/Editable-AllowEdits-Property-False.aspx

Cheers.

BW

Maver1ck666 said:
I have a main form which pulls down data based on the form it was open from.

What I want it to do is to look at a field it has just updated, and
depending on its result, either make AllowEdits = false or true (and a couple
of others).

I used the code:

If [Forms]![Frm UserViewBreach]![Str_Status] = "Rejected" Then

Me.AllowEdits = True
Me.AllowAdditions = True
Me.AllowDeletions = True
CmdSubmit.Enabled = True

Else

Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowAdditions = False
CmdSubmit.Enabled = False

End If

Now it runs through the code but I can can still make changes etc on the form.

What am I missing please?
Click to expand...
Click to expand...
 
Try saving the change to the record first.

If [Forms]![Frm UserViewBreach]![Str_Status] = "Rejected" Then

Me.AllowEdits = True
Me.AllowAdditions = True
Me.AllowDeletions = True
CmdSubmit.Enabled = True

Else

If Me.Dirty = True THEN Me.Dirty = False

Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowAdditions = False
CmdSubmit.Enabled = False

End If

I'm not sure that will do it, but I am pretty sure that if the record is
dirty the form's property can't be set so the it is not editable.


--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top