[MS_AccessPros] Visible or not

 

I have a combo box in which the user selects and options.  Depending on the option, additional fields show up on the form.  The combo box stores a value in a table, which is used later in a report.  The code is below. It works fine during the initial form completion.  However if I close the form and reopen it, the correct field do not show up.  Do I have to also put this code in the From “On Current Event”?   What if I have a few of these on one form, do I have to put code for all of them in the form “On Current” event?

 

Here is the code.

 

Private Sub cboOtherCoverage_AfterUpdate()

 

If cboOtherCoverage = 1 Then

Me.HelNameOfOtherCoverage.Visible = True

 

Else: Me.HelNameOfOtherCoverage.Visible = False

End If

 

End Sub

 

 

Bill

 

Bill Singer

Access 365

Minnesota

__._,_.___

---

Posted by: <bill.singer@at-group.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___