So, I have certain things that I want to hide/unhide based on another field. Here's what my code looks like:
.Code:Private Sub Form_Current() If Me.System = "Thomas" Then Me.Market.Visible = True Me.Region.Visible = True Else Me.Market.Visible = False Me.Region.Visible = False End If End Sub
The objects hide/unhide like they're supposed to, but it doesn't take effect until I save, refresh, or go to another record. Is there a way to make it so the objects hide/unhide immediately after the other field is changed?