Sort entries in textbox

[scarlet1978]

Hi,

I currently have a textbox in my form which is linked to a table. I use the textbox to scroll between entries and to add new entries. I would like it to show the table entries sorted alphabetically, not as it is currently doing which is sorting by the primary key. Is this possible?

 

[Frink]

Hallo,

If you open your form in design view, select your textbox and select view->properties, what is the in the titlebar of the properties window?

Also what is the controlsource or rowsource property

- Frink

 

[PHV]

Why not using a ComboBox with the RowSource property set to a SQL string containing an ORDER BY clause ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[scarlet1978]

Thanks for all the responses, but I admit I am a bit confused.

Firstly, I am not using a combobox because I am having problems with new entries - it keeps confusing the account name, which I add, with the primary key account ID. Is there something I am doing wrong? I set the row source to the relevant table, the linked column to 1 (the key), and the widths of the columns to 0cm;2cm, as I would for a standard combobox. However, for new entries it puts the ID in the name etc etc.

What is meant by the titlebar of the properties window? (This may be really obvious but I am trying to use access in a languange I don't speak...)