How do you refresh ".visible" components when moving to a new rec

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to activate code within a new record 3
Need help with Tabs 2
Timer Issue 2
goof up in a yes/no update field code 7
Reading a field when field is locked? 13
Text box visible on a continuous form 3
Novice Coding Questions 5
.VISIBLE Not Working Perfectly 2

Top