How to disable text field controls in subform

[vangx222]

Hi. I have a main form and a sub form.

In my mainfrm I have a text field that is REQUIRED before I can enter any data into the subfrm.

Can anyone help me with this code and how I would relate the two? I know how to do it when all the controls (text fields) are on the same form, but when it's a sub form and a main form then I don't know how to do it anymore.

Help please?

This is what I used for controls that are within the same form.

I tried this

Me!subfrm.Form!ControlName.Enabled

and placed this on the On Load of the mainfrm and After Update of the control in the mainfrm, but it didn't work.

When you are using this syntax:

Me![COLOR=#ff0000]subfrm[/color].Form![COLOR=#ff0000]ControlName[/color].Enabled

what does subfrm and ControlName refer too?

is subfrm the name of the control in the SUBFORM or MAINFORM and same question for ControlName?

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vangx222]

PHV, I looked at the information on that link and it didn't help me much. Someone also suggested this link,

http://www.mvps.org/access/forms/frm0031.htm

and I'ved tried these syntax as wells and it's not successful either.
It works if I'm in the SUB form and want to disable a field in the MAIN from, but it does NOT work vice versa, MAIN form to SUB form. The message I receive is: "You can't disable a control while it has focus."

..but I can't seem to find where or what the focus is.

Any suggestions?