I've got completely stuck on this one.
I have table [Agents] which is not in alphabetical order and I am adding to it daily. Now that I have over 20 entries I need to get it in order.
There are 3 fields in the table: AgentID; AgentName and PhoneNumber.
I have created a query based on the table and this I have sorted into Alphabetical order based on AgentName.
However, I cannot get the AgentName to populate the [Agent} control on the form - I always get the PhoneNumber irrespective of where I have the order of the query columns: whether [AgentName] is column 1 or 2 in the query.
In the [Agents] control row source I have:I am not using AgentsID in the query as I have found that the result is in numerical order not alphabetical order that I want (though this is the only time I got the AgentsName to populate the [Agent ]Control.Code:SELECT [AgentName], [PhoneNumber] FROM [Agents Query] AS Query;
Any help gratefully received and thanks in advance for your trouble.