Filling a combobox with field names.

[millerdav99]

Ok, so I have a combo box that populates with the names of fields of a table. I did this by using the combobox properties setting control source to the table name and source type to field list.

The problem is, in my haste to learn and create this project, the fields of the table are not in a real logical order and the ID field shows up. Is there a way to query the field names and sort them that is better then just changing the combobox's properties?

[ajetrumpet]

sure there is. you can do it in code, and you can also manually type them in a VALUE LIST. if they don't change often, why don't you just do that?