Combo box to sort data on form

R

RLN

Re: Access 2003
I have a subform that has tableX as its data source, and the subform displays
data in "continuous forms" view.

While there are about 12 columns in this view, the user wants
to be able to sort the data from choosing a field in a combo box.

When this form/subform loads, does anyone have a code sample that loads the
column names of a table into a combo box placed on the main form that would
use the description of the column (not the actual column name) then when a
column is chosen from this combo it would sort data in the subform in
ascending order?

Thank you.

RLN
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Combo box 0
Retain combo box order 2
Split form 0
Prevent duplicate selection from combo box on continuous form 4
Sort form records by field looked up in another table 1

Top