List Subform Records In Order
List Subform Records In Order
Hi All,
How do I list subform records in alpha or numeric order? For example lets say the subform contains first and last names and I want the last names displayed in order then first names in order. When I select the Order Alphabetical check box (see attached) it does nothing for me. Any help would be greatly appreciated.
Thank You
Re:List Subform Records In Order
Hi there...
I think you can look in "query by model" there you can define what you need.
Kind regards
Markus
Re:List Subform Records In Order
Hi. You are in the wrong ballpark here my friend.
This is for listing fields in alphabetical order when you create the layout.
What you are looking for is the QBM. Here you can sort, filter as much as you like.
If you create a relationship without constraints you can actually have a dynamic relationship by inserting the filter here.
Re:Re:List Subform Records In Order
Thank you so much for your help. I tried this and it didn't seem to work for me. I'm sure it is something I am doing wrong. I was wondering if your app is available for download or if there was a simple app that I could download using QBM.
Re:Re:Re:List Subform Records In Order
It is quite straight forward when you get the hang of it.
In this sample we simply sort the subform on surname (1) and firstname (2) we have also showcased how you can select further in the subform by using a global variable and filter the subform based on that.
You find the QBM by going to Document / Query by Model (QBM) in Design Mode.
Have a go.
Re:Re:Re:Re:List Subform Records In Order
Thank you very much for your help. Once I created a simple form with one subform it worked great. My other form will never work however because it is several subforms deep I.E. subform in a subform in a subform… Thanks again for your help though.
Re:Re:Re:Re:Re:List Subform Records In Order
You can order on as many levels as you like. But you can't directly order a level further out based on something which is lower down.
It is hard to say how you can get it right without seeing what you try to do.
is this a subform for editing of searching etc?