I have a combo box with its column heading property set to yes. This combo box has 4 columns:Name, LastName, City, Position. I'd like to sort by Name if I click on Name's heading, or to sort by City if clicking on City's heading. Is this possible?

Thank you!

If it can be done it would require some fairly complicated coding .. as it is not a standard feature in Access.

RDH

what do you suggest?

Hi
Use a listbox with command buttons along the top that sort by selected column name.

Can you supply code or an example?

Thanks a lot!

Hi
Have a look at the attached demo..