How do I sort the entries in my combo box?

[JimJones]

Hi,

I have just put a combo box on my form.
It works just like expected, for what I want to do, but
what would make it ideal, is if it could be sorted by
name.

The way it is currently sorted, is numerically, according to customer number, but I have only one field in my combo box (the last name for easy look up).

Please advise.

Thanks,
Jim

 

[Mile-O]

Change the query that form's the combo's RowSource - sort whatever field you want Ascending.

 

[JimJones]

Hi,

It's not working for me.
Likely it's my design.

I added the combo box directly to the form, using the wizard.
I find no place, not even in the linked table, to where I can sort the records one way or another.
I do not believe I have a query driving the form.

Even if I sort the form field, it will sort for that instant, but if I exit the database and open it again, it's the default way, which I think is numerically. ( I don't even know how 'it decided' to sort by customer number, now that I think about it).

Somehow, wether or not the program has sorted by customer number, it does sort by the order in which records have been entered.

I do have an auto-number field for customer number.

Can you help further, or do I have to completely alter my form design, making it get all the data from a query?

Thanks,
Jim

 

[JimJones]

Hi again,

I got it !
I had to hunt around a little bit, and learned something
new.

Thanks for your help,
Jim