SnowPatrol
Registered User.
- Local time
- Yesterday, 18:27
- Joined
- Feb 18, 2006
- Messages
- 17
Hi, I have tried the code on Dev's Access site but it does not work for me.
I have four listboxes populated by queries. For each one I have added a UNION Select "All" which works fine. I have also set "All" as the Default. All I need to do now is to ensure that the "All" choice is at the top of the list. The listboxes behave alphabetically at the moment so "All" is not the first choice. If I put it in brackets as Dev's site suggests it goes to the top of the list but then doesn't work. I am sure this is simple but cannot find a solution, either already posted, or in my muddled brain.
Any help greatly appreciated.
Ali
I have four listboxes populated by queries. For each one I have added a UNION Select "All" which works fine. I have also set "All" as the Default. All I need to do now is to ensure that the "All" choice is at the top of the list. The listboxes behave alphabetically at the moment so "All" is not the first choice. If I put it in brackets as Dev's site suggests it goes to the top of the list but then doesn't work. I am sure this is simple but cannot find a solution, either already posted, or in my muddled brain.
Any help greatly appreciated.
Ali
