paul.hartland at fsmail.net
paul.hartland at fsmail.net
Wed Jun 8 06:55:49 CDT 2005
To all, I have a lot of text boxes, combo boxes and check boxes on a form and need them locked for certain users I tried the following code to loop through them and when txt, pv or chk is found to lock or disable the control but it doesn't work.... Dim intFields As Integer For intFields = 0 To frmClient.Controls.Count If (Left(frmClient.Controls(intFields).Name, 3) = "chk" Or Left(frmClient.Controls(intFields).Name, 3) = "txt") Then frmClient(frmClient.Controls(intFields).Name).Locked = True End If If (Left(frmClient.Controls(intFields).Name, 2) = "PV") Then frmClient(frmClient.Controls(intFields).Name).Enabled = False End If Next intFields can anyone tell me what I am doing wrong cause I can't seem to see the wood for the tree's at the moment... Thanks in advance for all your help... Paul Hartland -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm