Simplicty and flexibility!

List Subform Records In Order

Started by Bolt-on-Trailers
You will need to Sign In to be able to add or comment on the forum!

List Subform Records In Order

Download: OrderAlpha.PNG

Hi All,

How do I list subform records in alpha or numeric order? For example let’s 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

Written by Bolt-on-Trailers 22/01/20 at 16:08:03 Dataease [{8}]FIVE

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


Written by Markus 22/01/20 at 16:57:37 Dataease [{8}]FIVE

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.

Written by DataEase 22/01/20 at 18:10:34 Dataease [{8}]FIVE

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.

Written by Bolt-on-Trailers 24/01/20 at 16:39:32 Dataease [{8}]FIVE

Re:Re:Re:List Subform Records In Order

Download Sample

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.

Written by DataEase 25/01/20 at 22:36:32 Dataease [{8}]FIVE

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.

Written by Bolt-on-Trailers 29/01/20 at 22:58:15 Dataease [{8}]FIVE

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?

Written by DataEase 01/02/20 at 11:38:33 Dataease [{8}]FIVE