Capturing Subform Edits

[yessir]

I have been stumbling over this problem for a while now and REALLY need some intervention on this.

I have a form subform which contains information and of course related information (one-to-many).

I need to capture the event of a change in the subform and set a radio button to enabled on the form.

Could someone please point me in the right direction here,

Thanks
~

 

[Rich]

Use the Before Update Event of the subForm

If Not Me.NewRecord Then
do something etc.
End If

 

[yessir]

that would be nice, but they can add a new record or edit a record that is already there.

And how do you set a from value from a subform,
or vise versa;
check a subform value from a form?

 

[Rich]

You could use something like this on the subForm,
Private Sub Form_Current()
If (Me.Dirty Or Me.NewRecord) Then
Me.Parent.Section(1).Visible = False
Me.Tag = 1
Else
Me.Parent.Section(1).Visible = True
Me.Tag = 0
End If
End Sub