Randall R Anthony
RRANTHON at sentara.com
Wed Jun 8 07:02:45 CDT 2005
Paul, This is what I'm currently using to do just what you described. I'm sure it can be manipulated to search on specific control names, although I have not done it because I don't need the specificity. For Each cCtrl In frmFormName.Controls If TypeOf cCtrl Is TextBox Then cCtrl.Locked = True End If If TypeOf cCtrl Is ComboBox Then cCtrl.Locked = True End If If TypeOf cCtrl Is DBGrid Then cCtrl.AllowAddNew = False cCtrl.AllowDelete = False cCtrl.AllowUpdate = False End If Next