order by not working without filter

I

Ian

I have a client form with the orderby property set to last name. I also have
two buttons. One to apply a filter (to show only active clients which
triggers a macro to filter the underlying table for only active clients) and
other to show all records (different macro to show all records). The orderby
works fine when the active client macro has been triggered but doesn't when
the show all records macro is hit. The Filter property reads as follows:
((((Main.Active)=-1)))
and the order by property:
[last name], [first name]
Any suggestions?
 

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

Top