Hi,
Access 2003
I have finally got my list from a table [Agents] (with 3 columns AgentID, AgentName and Phone) to show in my combobox. However, if I click on any name [AgentName] in the list I get a Windows or MS Access error sound. The selected name in the list does not stay visible in the combox control but does stay in the combobox list.
Control Source: =[Agent].[Column](2)
Row Source Type: Table/Query
Row Source: SELECT AgentID, [AgentName] FROM Agents;
Bound Column: 2
Any help much appreciated and thanks in advance.