Help with .enabled = False 1

[ffleitas]

Hello programmers,

On open I have a form activate this procedure:

Private Sub Form_Open(Cancel As Integer)
If Me!CommNumber = 1 Then
Me!Cleared.Enabled = False

Else

End If
End Sub

The problem I am having is that the all the rows which all have the field [cleared] (Yes/No) on the continous form are disabled if the condition of 1 is met. Is there a way to just disable the field [cleared] (Yes/No) that holds the condition in the row or rows ?

Thanks,
Felix

 

[danvlas]

Use the Current event.
In a continuous form it will create the impression that Cleared is enabled/disabled for all records, but moving from one record to another will actually enable/disable the control depending on the value in the current record.
In a single form it will be probably exactly what you need.

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html