murray83
Games Collector
- Local time
- Today, 03:06
- Joined
- Mar 31, 2017
- Messages
- 729
Good Morning,
this is my code
my aim is to lock the said cmbActionedBy so when a record is either done or refused it cant be altered
i have tried it in form load and also in the afterupdate part of the status as above but so far to no avail
any ideas what I am obviously doing wrong :banghead:
cheers all
attach is a screen shot of the table and form in question
this is my code
Code:
'lock selection box
Private Sub Status_AfterUpdate()
If Me.Status.Value = Me.txtStatusDone.Value Or Me.Status.Value = Me.txtStatusRefused.Value Then
Me.cmbActionedBy.Locked = True
Else
Me.cmbActionedBy.Locked = False
End If
my aim is to lock the said cmbActionedBy so when a record is either done or refused it cant be altered
i have tried it in form load and also in the afterupdate part of the status as above but so far to no avail
any ideas what I am obviously doing wrong :banghead:
cheers all
attach is a screen shot of the table and form in question