Joe Hecht
jmhecht at earthlink.net
Sat Jun 30 18:22:58 CDT 2007
I use this code to enable or disable code bases on weather an employee needs
licenses to work.
Private Sub CboJobTitle_AfterUpdate()
'If employee is not licensed diasable license controls
If Me.CboJobTitle = "Admin" Then
Me.cboIssueAgency.Enabled = False
Me.txtLicExpires.Enabled = False
Me.txtDotExpires.Enabled = False
Else
Me.cboIssueAgency.Enabled = True
Me.txtLicExpires.Enabled = True
Me.txtDotExpires.Enabled = True
End If
They can be hired as admin and later promote and need the licences.
Properties stay set when you close a database and reopen them unless another
event changes them, Is that a correct statement.
You forget so much when you do not do this for a year.
Thanks
Joe Hecht
jmhecht at earthlink.net