Subform problems

[Chinde]

Hi

I have a main form with a sub form on. I would like for the users to navigate the records on the main form and when the data changes in the main form the sub form will fire an event. I have tried the OnCurrent event for the sub form but this doesn't seem to work.

Could someone give me a little direction, I might just be thinking of this from the wrong direction??

Using Access 2007

[FishVal]

Oppositely the same - Detecting a Sub-Form event from the Main Form?

[Chinde]

Excellent, not got it going just yet but it looks just like what I need.

Thanks again.

[Chinde]

Here's what I ended up with for any future wanders.

Private WithEvents frmMainform As Access.Form
 
Private Sub Form_Load()
 
    Set frmMainform = Forms("frmMain")
    frmMainform.OnCurrent = "[Event Procedure]"
 
End Sub
 
Private Sub frmMainform_Current()
    'Do Stuff
End Sub

Placed this on the sub form with the frmMainForm pointing towards the main form and the rest was history.

Works a treat!!

[NeoPa]

Thanks for the update Chinde :)