Filter

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

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!!!
 
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!!!
Click to expand...

After setting the OrderBy property also set OrderByOn to True.

me.orderby = "[launch] desc"
Me.OrderByOn = True
 
Thanks Fred. That is still not working for me. Do I put that on the form or
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!!!
Click to expand...

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
.
Click to expand...
 
Back
Top