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