Thread: Filter
View Single Post
  #3  
Old May 5th, 2010, 03:41 AM posted to microsoft.public.access.forms
PJ
external usenet poster
 
Posts: 265
Default Filter

Thanks Fred. That is still not working for me. Do I put that on the form or
on the text box in the form

"fredg" wrote:

On Tue, 4 May 2010 11:36:10 -0700, PJ wrote:

I have a filter on a form based off of multiple criteria. Once you put the
criteria I have a command button to search for this criteria based on what
you put in the unbound fields. Once the filter is placed it is outputting
the correct information but I want it th order by the launch date in
descending order. Here is my code me.orderby = "[launch] desc". I guess I am
placing the event on the incorrect event. Do I put it on the form or the
text box and what event?

Thanks!!!


After setting the OrderBy property also set OrderByOn to True.

me.orderby = "[launch] desc"
Me.OrderByOn = True
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.