Make subform control invisible depending on value in mainform.

[Richie27]

Hello everybody,

I want to make a control on a subform invisible depending on the value that's in one of the boxes on a mainform.

I had this behind the on change event of the mainform. Doesn't work though. Boo!



Dim cc_ID As Integer

cc_ID = [Forms]![frmFN_FilesBox]![fkCostCentre_ID]

If (cc_ID = 2) Then

Me![subform].form.cboDesc.Visible = False

End If

Rich.


-----------------------------------------------------

[Richie27]

oh lord. there was nothing wrong with my code as such. Just used a wrong name for control.

Thank crunchy it's Friday!!!!