GoVikings
Last Activity: Oct 25 '15, 04:50 PM
Joined: Sep 26 '15
Location:
-
GoVikings replied to Subform data cannot sort (ascending) according to data (from non-primary key field) fin AccessI found a solution, at least in my case. The primary key (autonumber) was the basis for the sort, regardless of what I asked for in my query. I have no idea why this is, but when I made the Name field = primary key, and sorted again, it worked. Of course, I am fortunate because there are no duplicate names - if there were, I'm not sure what I would do. -
GoVikings replied to Subform data cannot sort (ascending) according to data (from non-primary key field) fin AccessHi hvsummer
I did try to sort by the name field, both in the source table and then in the "record source" property of the subform (where I indicated to sort ascending by Name from the source table). But still, even though I ask to sort by Name, it seems bound to the ID number when sorting...Leave a comment:
-
GoVikings started a topic Subform data cannot sort (ascending) according to data (from non-primary key field) fin AccessSubform data cannot sort (ascending) according to data (from non-primary key field) f
Hi
Using MS Access 2010. Total newbie. Avoid using VBA where possible, always use the macro builders/expression builder.
I have a source table with:
ID - autonumber (primary key)
Name - text
Then I have a subform which displays multiple names from the source table. When I ask that subform sort the information, it does so according to the ID number data, not the alphabetical order of the...
No activity results to display
Leave a comment: