Subform disable return text

[hrg]

I have a form (frmOrders) within it i have a subform (subfriendorder which is always at the bottom of the main form). The subform is always disabled until you enter a number in a text field in the main form (fromorders). Once i have entered the data it enables a lets the user enter data into the subform(subfriendorder). When i want to leave the form via a button it should go back to the first text field in the main form and also disable the subform (subfriendorder).

I do not know how to return to the first text field and disable the subform using a button. Please could someone help.

I have tried the following


Forms!frmorder!TxtBatchNo.SetFocus

Forms!frmorder.SetFocus("Child58&quot.enable = False

**child58 being the subform in the main form

 

[MangroBongacello]

Not Forms!frmorder.SetFocus("Child58&quot.enable = False
But Forms!frmorder!Child58.Form.enabled = False

 

[rbowes]

Your syntax is wrong:
Not:
Forms!frmorder.SetFocus("Child58&quot.enable = False

Rather

Forms!frmOrder![Child58].enabled = false

To explicitly write it:

Forms("frmOrder).Controls("Child58&quot.Enabled = False

Either one should work.

Bob

 

[Skeptik]

Hi! your sintax is wrong!
try this:

[Forms]![frmOrder]![Child58].enabled = false

Skep