Unbound Text and Image Question on Form

  • Thread starter Thread starter TomP
  • Start date Start date
T

TomP

I have a field in my table called VI and it is formatted to yes/no. On this
form I added an unbound text control called LargeCheck and an image. This is
what I entered on the VI text box.

Private Sub VI_Click()
If Me.VI = 0 Then
Me.LargeCheck = ""
Me.Image294.Visible = False
Else
Me.LargeCheck = Chr(252)
Me.Image294.Visible = True
End If

Here is the problem:

When I click on the VI text (yes/no) field the unbound text and image will
respond correctly to the current record, but when I advance to the NEXT
record, the unbound text and image will not respond to the yes/not value on
that record unless I click on that field one more time. Is there a way I can
have the unbound text and image respond to whatever record is visible on the
form?

Thank you for your help,

Tom
 
TomP said:
I have a field in my table called VI and it is formatted to yes/no. On
this
form I added an unbound text control called LargeCheck and an image. This
is
what I entered on the VI text box.

Private Sub VI_Click()
If Me.VI = 0 Then
Me.LargeCheck = ""
Me.Image294.Visible = False
Else
Me.LargeCheck = Chr(252)
Me.Image294.Visible = True
End If

Here is the problem:

When I click on the VI text (yes/no) field the unbound text and image will
respond correctly to the current record, but when I advance to the NEXT
record, the unbound text and image will not respond to the yes/not value
on
that record unless I click on that field one more time. Is there a way I
can
have the unbound text and image respond to whatever record is visible on
the
form?
Click to expand...


Use the form's Current event to execute the same set of statements.
 
Back
Top