Subform not firing event

[SQLScholar]

Hey all,

I dont "do" access stuff very often and i am struggling.

I have a form\subform all working fine. However on the subform design i have added this

Private Sub Form_AfterUpdate()
Me.Form.OrderBy = "OrderKey"
Me.Form.OrderByOn = True
End Sub

This works fine when i view the form on its own, however when i call it as a subform it doesnt seem to fire.

Any ideas why?

TIA

Dan

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

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[dhookom]

Have you tried to debug the code to make sure its being run when a subform?

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya SQLScholar . . .

I've never seen the [blue]form property[/blue] used that way with [blue]Me[/blue]. Typically its used to reference a subform from from code residing in the subforms parent form ... as in:

[blue]Forms!MainFormName!subFormName[purple][b].Form[/b][/purple].ControlName[/blue]

You should drop the form property and try:

[blue]Me.OrderBy = "OrderKey"
Me.OrderByOn = True[/blue]

[blue]Your Thoughts? ...[/blue]

See Ya . . .

Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!