A
adrian007uk
Hi I am having a problem with a yes/no option on a form. I have two fields
and i am wanting to relate them to each other. The first is called 'signed'
and is the yes/no field. The second is 'signed information' and this is a
text field. I have some code (kindly supplied by a contributor on here) that
makes the 'signed information' field visible if 'signed' is checked. This
has been entered in 'after update':
Private Sub Signed_AfterUpdate()
If Me.Signed = True Then
Me.Signed_Information.Visible = True
Else
Me.Signed_Information.Visible = False
End If
End Sub
The code works great but when i enter a new record the form repeats what was
entered into the previous record (i.e., if 'signed' was checked 'signed
information' is visible). How can i make the default value set as 'No' and
keep 'signed information invisible unless 'signed' is checked?
I have tried setting the default value in the table and from the control on
the form to 0 but this does not seem to have any effect.
and i am wanting to relate them to each other. The first is called 'signed'
and is the yes/no field. The second is 'signed information' and this is a
text field. I have some code (kindly supplied by a contributor on here) that
makes the 'signed information' field visible if 'signed' is checked. This
has been entered in 'after update':
Private Sub Signed_AfterUpdate()
If Me.Signed = True Then
Me.Signed_Information.Visible = True
Else
Me.Signed_Information.Visible = False
End If
End Sub
The code works great but when i enter a new record the form repeats what was
entered into the previous record (i.e., if 'signed' was checked 'signed
information' is visible). How can i make the default value set as 'No' and
keep 'signed information invisible unless 'signed' is checked?
I have tried setting the default value in the table and from the control on
the form to 0 but this does not seem to have any effect.