Got another question for you. I use the following formula to disable/enable controls in Form 1 based on a selection of a combo box in Form 1:
If Me.Combobox.Value = "Item1" Then
For Each ctl In Me.Controls
ctl.Enabled = True
ElseIf Me.Combobox.Value = "Item2" Then
For Each ctl In Me. Controls
If ctl.Tag = "Item2" Then
ctl.Enabled = False
It works great. What I want to do now is to disable controls in Form 2. I tried copying the same code in the Current event of Form 2, but a get a Run-time error '438 - object doesn't support this property or method.
I'm hoping I don't need to call out each control separately in Form 2's Current event. Is there a better (shorter code) way?