Sorting continuos form with combo

[Andrew Ofthesong]

Hi, i have a continous form, with comboboxes.

the combobox reads "IdName", that is numeric, and shows the corresponding
name via lookup...

so, if i do a

me.orderby="[IdName]"

i'll get the records sortes numerically, not alphabetically by the
correspondign name...

so if,
1 -> zoe
2 -> Abel
3 -> Joe

the sort will give me zoe, abel, joe. Instead of "abel", "joe", "zoe"

 

[Rowland]

try having your IdName combo box show the name of the
person and not the number.

Then set your me.orderby like this

me.orderby=me.whatever the name of your combo box is.

I didnt test this theroy like i normally do, it was just
an idea.