H
hungrymonkie
I am setting up a database that provides an interviewer scripting based on
the respondents feedback. I am using the ".visible" feature for many of the
fields. It is working, however, when the interviewer moves to the next record
(next customer to call), the code does not "refresh" and all the fields still
show based on the last record.
Is there any way to have the field's .visible default back to false when the
interviewer moves to the next record?
Example of coding:
Private Sub Frame731_AfterUpdate()
Select Case Me!Frame731
Case 1
[Label758].Visible = False
[Box757].Visible = False
[Box759].Visible = True
[Label761].Visible = True
[Label762].Visible = True
[Label739].Visible = True
Case 2
[Label758].Visible = True
[Box757].Visible = True
[Box759].Visible = False
[Label761].Visible = False
[Label762].Visible = False
[Label739].Visible = True
End Select
End Sub
the respondents feedback. I am using the ".visible" feature for many of the
fields. It is working, however, when the interviewer moves to the next record
(next customer to call), the code does not "refresh" and all the fields still
show based on the last record.
Is there any way to have the field's .visible default back to false when the
interviewer moves to the next record?
Example of coding:
Private Sub Frame731_AfterUpdate()
Select Case Me!Frame731
Case 1
[Label758].Visible = False
[Box757].Visible = False
[Box759].Visible = True
[Label761].Visible = True
[Label762].Visible = True
[Label739].Visible = True
Case 2
[Label758].Visible = True
[Box757].Visible = True
[Box759].Visible = False
[Label761].Visible = False
[Label762].Visible = False
[Label739].Visible = True
End Select
End Sub