bgaye1979
Last Activity: Nov 15 '07, 11:58 AM
Joined: Nov 5 '07
Location: Rhode Island
-
Thank you so much. It worked perfectly fine.... -
Thank you for the assistance. I tried it as you said but the checkbox is not updated( or checked automatically) for records where the ReturnedDate is Not Null with the code below;
Private Sub ReturnedDate_Af terUpdate()
If IsNull(Me.Retur nedDate) And Me.FileReturned = True Then
Me.FileReturned .Value = False
Else
'do nothing
End If
End Sub
Do you have any further assistance?...Leave a comment:
-
Thank you. I did but the code didn't work. Any idea?...Leave a comment:
-
Me.Checkbox Script in VB
I have a form and there is a Yes/No Checkbox as a datatype. This field is called FileReturned. There is another field called ReturnedDate.
If the ReturnedDate field is Null, I want the checkbox to be unchecked automatically, else the checkbox should be checked. Can someone help me with the code and where to write it? Should it be on the form's current event or before update?
Here's it what i have?
If...
No activity results to display
Leave a comment: