Applying sort to subform using command button

[Guest]

Hi,

All I want to do is sort a form based on a date field in ascending order and allow the user to sort the form from a command button, instead of using the toolbar. If my form is called mainForm and the subform subForm, what sort of macro or code do I have to provide?

Thanks in advance,

Jeff

 

[PC Datasheet]

It sounds like all you need to do is base your subform on a query rather than a
table and set the sort order in the query to ascending on the date field!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Hi,

All I want to do is sort a form based on a date field in ascending order and

allow the user to sort the form from a command button, instead of using the
toolbar. If my form is called mainForm and the subform subForm, what sort of
macro or code do I have to provide?

 

[Guest]

Hi,

I already have that. I was just hoping to have the ability to sort by date or by a name field and have buttons to enable those sorts. Is that a possibilty?

Thanks,

Jeff

 

[PC Datasheet]

Yes, look at the OrderBy property in the Help file. You would put the following
code in the OnClick event of a button:
Me.OrderByOn = True
Me.OrderBy = "[MyDateFieldname]"

You would do the same for the name field.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Hi,

I already have that. I was just hoping to have the ability to sort by date or

by a name field and have buttons to enable those sorts. Is that a possibilty?