orderby subform

[cpampas]

Hello
I set the order of by subform data by clicking on a subform label :

Me.OrderBy = "[data] Asc"
Me.OrderByOn = True

but, I would prefer to do it, from the main form by clicking on a command button. Like this, wich does not work :

Me.OrderBy = "Forms!frmMyMain.frmMySub.Form![data] Asc"
Me.OrderByOn = True



any thoughts about this
thanks

 

[theDBguy]

Hi. You could try it this way:

Me.SubformControlName.Form.OrderBy="[data]"
Me.SubformControlName.Form.OrderByOn=True

 

[cpampas]

It works great
Thanks a lot

 

[theDBguy]

Hi. You're welcome. Good luck with your project.