Control subform textbox from Master form checkbox

[bubai]

My bound master form has bound subform in it and both of them has linked fields. In the master form i've placed a checkbox which if unchacked will lock and disable a textbox in the SUBFORM, and if checked will enable and unlock the textbox and fill it with a calculation result, which will then be passed on to the underlying table.
Now, suppose in the master form (named X), i have A (checkbox) and B (textbox with numeric value) and in the subform (named Y), i have C & D (both textboxes with numeric values). Hence if A is checked, I'd like D to return the result of - "B*C". Or else D will remain locked and disabled. Is this possible?

[burrina]

Here is an Example: Of course change names to match yours. Main form is based on a query with both tables linked.

If Me.AChkBox = True Then
[frmY].[Form]![Dtextbox] = Me.Total
[frmY].[Form]![Dtextbox].Enabled = False

Me.Dirty = False
Else
[frmY].[Form]![Dtextbox].Enabled = True
End If

[bubai]

Dear burrina, I have place the code but not working:

Private Sub Form_Current()
If Me.A= True Then
Y.Form!D.Enabled = True
Y.Form!D = Me.B * Y.Form!C
Else
Y.Form!D.Enabled = False
Y.Form!D.Dirty = False
End If
End Sub

May be I can not REFER the subform properly.

[burrina]

Are those the actual names of the controls and forms? Adjust your code to reflect the example I posted.

[bubai]

The database is still in experimental stage and for the sake of simplicity they are the actual names. Please point me if anything is out of sync in the code. I SUSPECT I HAVE MISSED THE WAY I SHOULD REFER TO SUBFORM. Please let me know.

[June7]

I think burrina's code should work. What happens - error message, wrong results, nothing?

However, suggest you name the subform container control different from the object it holds, like: ctrY. Then:

Me.ctrY.Form.D.Enabled = True

Also suggest using meaningful names and establishing a good naming convention. That way if you like the results don't have to go back and totally rebuild.

[bubai]

It says "compiler error. variable not defined" and highlights the Y in the 3rd line of the code blue.
Please check my code. Y is the name of the subform within the master form.

[June7]

Actually, just realized burrina's code is missing something. Correct syntax would be:

Forms!mainformname.subformContainerName.Form.contr olname.Enabled

or

Me.subformContainerName.controlname.Enabled

Review post 6 again.

[bubai]

Yes. The problem was with referencing the subform. Along with this I've also found another workaround by placing the code in the subform's class module. That way i refered the subform controls with Me! and master controls with Form(0). I have added another two more lines of code which would return the D value to null if A is unchecked:

Me.D = Null
Me.D.Locked = True

Also removed a line of code from burrina:

Me.Dirty = False

However there is still a problem. All of these code takes effect once i move to next record. IS THERE A WAY, WHICH WILL INSTANTLY SHOW THE OUTPUT OF "D" DEPENDING ON CHECKED/UNCHECKED STATUS OF "A" WHILE I'M IN THE SAME RECORD?

[June7]

Code in the AfterUpdate or Click event of checkbox.

[burrina]

The code I posted was NOT air code, it was tested and worked. Only the names and Events for the code being fired needed to be changed. As to the Me.Dirty = False
If you prefer to not save it after the change, that is up to you. I'm sure my setup and yours were not the same.

Good Luck With Your Project!

[June7]

Yeah, took another look and your code should have worked.

[bubai]

Dear burrina,
the fact is that your code required the Forms! collection and Masterform reference to work with. Anyway, thanks for the help. However, would you care to clarify me the "Me.Dirty = False" statement, it looks like the form is still saving the changes without it.
Dear June,
it worked accordingly after I put it in the checkbox afterUpdate event. Thanks a lot for the help and advice.