Change enabled on control based on data in subform?

[Ron]

Hi all,

I've got a combo box control (cboYoMomma) on a main form (frmMain) that I
want to enable only if a subform (sfrmSubForm) does not have any records in
it. But, once there are records in the subform I want to un-enable that
combo list so it can't be changed. And, if all the records on the subform
are removed, I want to re-enable that combo box control.

Is that possible? And if so, how?

TIA
ron

[Salad]

Ron wrote:

Hi all,

I've got a combo box control (cboYoMomma) on a main form (frmMain) that I
want to enable only if a subform (sfrmSubForm) does not have any records in
it. But, once there are records in the subform I want to un-enable that
combo list so it can't be changed. And, if all the records on the subform
are removed, I want to re-enable that combo box control.

Is that possible? And if so, how?

TIA
ron

In the OnCurrent event of MainForm enter
Me.cboYoMamma.E nabled = (Me.sfrmSubForm .Form.Recordset clone.RecordCou nt
= 0)

In the AfterDate event of the Subform enter
Forms!MainForm! cboYoMamma.Enab led = False

I suppose you might want to do a check if you delete records too in the
subform.