Multiple Sort Criteria

[FrankMars]

I have a continuous form (Form 1) which is sorted by a combo box on a second form (Form 2). I have written the following code on the open event of Form 1 which works fine;

Me.OrderByOn = True
Me.OrderBy = Forms!zzfbCriteriaSortBy![cbxSortBy]


I would like to add a secondary sort. I have added a second combo box on Form 2 and changed the code on the open event of Form 1 to the following which DOES NOT WORK;

Me.OrderByOn = True
Me.OrderBy = Forms!zzfbCriteriaSortBy![cbxSortBy],Forms!zzfbCriteriaSortBy![cbxSortBy2]

I've also tried;
Me.OrderByOn = True
Me.OrderBy = "Forms!zzfbCriteriaSortBy![cbxSortBy],Forms!zzfbCriteriaSortBy![cbxSortBy2]"

I've also tried;
Me.OrderByOn = True
Me.OrderBy = "[Forms]![zzfbCriteriaSortBy]![cbxSortBy],[Forms]![zzfbCriteriaSortBy]![cbxSortBy2]"

Is it possible to have multiple sorts? What am I doing wrong?

Thank you in advance.

 

[dhookom]

I would try:

Me.OrderByOn = True
Me.OrderBy = Forms!zzfbCriteriaSortBy![cbxSortBy] & "," & Forms!zzfbCriteriaSortBy![cbxSortBy2]

I'm not sure how/if this would work if you have spaces in your field names.

Duane
Hook'D on Access
MS Access MVP

 

[FrankMars]

That worked Duane - Thanks very much.