Sorting continuos form with combo

  • Thread starter Thread starter Andrew Ofthesong
  • Start date Start date
A

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"
 
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.
 
Back
Top