List box problem

[MaxRott]

I have a list box which I display all the entries in my table, I want the user to beable to select an entry, my problem is that while selecting entries it highlights the selected one, then when you select another entry it highlights both, I cannot get rid of multiple selection, which makes it very confusing. Any suggestions?

 

[IMO]

In the listbox properties change 'Multi Select' to 'None'

IMO

 

[MaxRott]

That was my first reaction but it is already set to 'None'
The row src is as follows
SELECT [APC].[APC_ID], [APC].[APC_Company], [APC].[APC_ATTN] FROM APC;
the list box updates itself from the other data on the form.