Check Box

[Guest_imported]

I want to create a check box on the Form so whenever the user select it, Some fields will be disabled. Below is the function:

Private Sub USB_Click()

If ([USB].Value = -1) Then
[USBID].Enabled = True
Else
[USBID].Enabled = False
End If
End Sub

However, this function will take effect on all records, not with the current record.

Thanks in advance,

 

[rhicks]

I take it that you are refering to a continuous form. This is normal behaviour. If you change the property of a control on a continuous form, it effects all records for the control chosen.

HTH
RDH
Ricky Hicks
rdhicks@mindspring.com

 

[uyen]

I'm still confusing....what do I have to do so it only effect the current record, not all the records....