I have a main form and a subform. The main form has a combo box
control and the subform has a textfield.

What I want to do is when the main form loads it should check the
value of the combo box and if it, lets say "MZ" then the textfield in
the subform must be enabled otherwise it should be remain disabled.
This should be done without setting any explicit focus.

Any help would be greatly appreciated.

Rex wrote:

> I have a main form and a subform. The main form has a combo box
> control and the subform has a textfield.
>
> What I want to do is when the main form loads it should check the
> value of the combo box and if it, lets say "MZ" then the textfield in
> the subform must be enabled otherwise it should be remain disabled.
> This should be done without setting any explicit focus.
>
> Any help would be greatly appreciated.

In the MainForm's OnCurrent event you could enter something similar to
Me!SubFormName!Textbox.Enabled = (Me.ComboboxName = "MZ")

Free
http://www.youtube.com/watch?v=nblsi4Ke_qA

Here is one thing you could try:

Private Sub Combo10_AfterUpdate()
If Combo10 = "whatever" Then
Me.frmSubForm.Controls("Text0").Enabled = True
'--or
'Me.frmSubForm.!Text0.Enabled = True
End If
End Sub

Rich

*** Sent via Developersdex http://www.developersdex.com ***