Sorting records in a subform

G

Gary

I have a form with a subform (subform based on a query).
I am looking for code that can sort the records in the
subform by clicking on a command button.

Thanks,

Gary.
 
M

Marshall Barton

Gary said:
I have a form with a subform (subform based on a query).
I am looking for code that can sort the records in the
subform by clicking on a command button.
Click to expand...


If the buttom in on the main form:

Me.subformcontrol.Form.OrderBy = "nameoffield"
Me.subformcontrol.Form.OrderByOn = True

If the button is in the subform:

Me.OrderBy = "nameoffield"
Me.OrderByOn = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
DLookup in Continuous form 0
VBA code returns no records hwenKey ID is added 14
Referring to control in the active subform 0
subform based on external SQL won't requery 1
undo sorts button 2
Using one command button to open one of two reports 3
main form/subform 1

Top