Filter

[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!!!

 

[fredg]

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

 

[PJ]

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!!!

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
.