combobox code not running except afterupdate

[Udaman]

I have a bound combo-box with 5 choices that simply hides or shows different controls based on selection. I made it bound so that the value is retained when the form is closed and reopened. However, despite the value being remembered, the code doesn't run unless I re-select an option from the list. I have read numerous posts, but I can't quite find one that deals with this issue specifically. My best guess is that my form needs to run the code every time it opens (perhaps the On Current or On Load events?), but that is where I need help in figuring out where, and what code I need to use. Any suggestions?

Here are some details:

My form is called "BulbsQueryForm"
The Combobox is called "AssetModel"

Here is my code for the combo box set in the After Update Event Procedure:

Private Sub AssetModel_AfterUpdate()If AssetModel.Value = "Tundra" Then
      Me.TwoPlateCheck.Visible = True
      Me.TwoPlateRR.Visible = True
      Me.PlateCheck.Visible = False
      Me.PlateRR.Visible = False


 Else
      Me.TwoPlateCheck.Visible = False
      Me.TwoPlateRR.Visible = False
      Me.PlateCheck.Visible = True
      Me.PlateRR.Visible = True


 End If


End Sub

Any suggestions?

 

[xenou]

Yes, run your code in a form open event. Have you tried it?

 

[Udaman]

Yes, it worked on the Open event. Thanks for the tip, I was hoping I was on the right track. Someday I might even be able to help answer some of these posts!

 

[xenou]