Sort data on a subform 2

[TommyTea]

Hello. I need to sort data displayed on a sub-form by running code from a command button on the main form. I tried forms("frmMain.form.frmSubForm&quot.OrderBy = fieldname and every permutation that I could think of. Any wisdom out there? Thanks.

 

[psemianonymous]

Basically you need to walk the following property structure:

Forms!frmMainForm!ctlSUBFORM_CONTROL_NAME_HERE.Form.OrderBy

So figure out what the name of the subform *control* on the main form is, then use that name to access the subform itself. The name of the subform itself is in this case irrelevant.

 

[cghoga]

DoCmd.GoToControl "YourSubformName"
DoCmd.GoToControl "YourFieldName"
DoCmd.RunCommand acCmdSortDescending