Lock fields if statusID=1

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

I have a form with prospects: fields prospectid, name, address etc. and a
field statusID.

Is there a way to disable editing and deleting of all the fields of the
statusID for a prospect is like 1? If the statusID is changed to 2 editing
should be possible again...

Tried some if then statements behind the on opent event but can't get it to
work.

Thanx in advance for any tips.

Regards,

Harmannus
 
Hallo,

I have a form with prospects: fields prospectid, name, address etc. and a
field statusID.

Is there a way to disable editing and deleting of all the fields of the
statusID for a prospect is like 1? If the statusID is changed to 2 editing
should be possible again...

Tried some if then statements behind the on opent event but can't get it to
work.

Thanx in advance for any tips.

Regards,
Harmannus
Click to expand...
In the Forms Current event:
If Me![StatusID] = 1 Then
Me.AllowEdits = False
Me.AllowDeletions = False
Else
Me.AllowEdits = true
Me.AllowDeletions = True
End If
 
Hallo,

Thanx for the response!

Works great.

Thanx.


Regards,
Harmannus

Hallo,

I have a form with prospects: fields prospectid, name, address etc. and a
field statusID.

Is there a way to disable editing and deleting of all the fields of the
statusID for a prospect is like 1? If the statusID is changed to 2 editing
should be possible again...

Tried some if then statements behind the on opent event but can't get it to
work.

Thanx in advance for any tips.

Regards,
Harmannus
Click to expand...
In the Forms Current event:
If Me![StatusID] = 1 Then
Me.AllowEdits = False
Me.AllowDeletions = False
Else
Me.AllowEdits = true
Me.AllowDeletions = True
End If
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
Click to expand...
 
Back
Top