Field visibility based on ComboBox selection

[cactuspete13]

I have a form that will have several dropdown combo boxes, each option will cause a series of fields to change from invisible to visible. I got the first part of that to work. The problem I am having is while flipping through the records, that field remains visible/invisible based on the last selection. Below is the code I am using. The first combobox is named Involved (both name and control source), and the second is named Involvement (name is Label37, haven't gotten around to renaming it yet). How do I get it to adjust the Visible setting based on the Involved combobox and retain that setting for each record?

Here is the code I am using:

Private Sub Involved_Change()
If Involved = "Yes" Then
Label37.Visible = True


Involvement.Visible = True
Else
Label37.Visible = False
Involvement.Visible = False
End If
End Sub

Edit: Also, how would I accomplish the same thing (adjusting the visible settings and making them change with the record) to tabs?

[Missinglinq]

Assuming that Involved is Bound to a Field in your underlying Table, and that the Form is in Single View (which I assume to be true, considering the question about a Tabbed Control) you need to place the same code in the Form_Current event, as well as the OnChange event. The same thing would apply to the formatting of the Tabbed Control.

Code pretty much has to be in the Form_Current event anytime you want formatting changes to be Record-specific.

Doing formatting to Continuous or Datasheet View Forms is limited, in most cases, to using Continuous Formatting from the Menu/Ribbon, and has a limited set of Options.

Linq ;0)>

[cactuspete13]

Awesome, works perfect. Thank you.

[Missinglinq]

Glad we could help!

Linq ;0)>