Linking Field on SubForm to Field on Main/ParentForm?

[Buckar00B0nzai]

I have a Form (Form.Main) with a subform (Form.Sub) embedded in it. Here's what I would like to do.

If I update a field (Status) on the subform, can I force it to update a field on the main form with an IF statement? I'm thinking:

Private Sub Status_AfterUpdate()
If Me.Status.Value = "Blue" Then
Me.NEED HELP HERE.Value = Now()
Else
End If
End Sub

Am I even close?

Thank you for your help.

Buckaroo Banzai

http://www.strategicorps.com

 

[PHV]

As a starting point, replace this:
Me.NEED HELP HERE.Value = Now()
with something like this:
Me.Parent.Form![name of control].Value = Now()

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

 

[MajP]

I do not like to do this in my suforms, because I like to reuse subforms. So instead I trap the event in the main form without any code in the subform. Basically the main form listens for a subform event to occur.

Private WithEvents subFrmControl As Access.TextBox

Private Sub Form_Load()
Set subFrmControl = Me.SubFormName.Form.ControlName
subFrmControl.AfterUpdate = "[EventProcedure]"
End Sub

Private Sub subFrmControl_AfterUpdate()
'Capture the subform event here
MsgBox "SubFormChanged"
End Sub