List box phenomina

[Chrisopia]

My list box is behaving very strangely...

I am just learning about the multiple selection tool and found a snippet of coding on the Microsoft website that works a treat

http://support.microsoft.com/kb/827423

I can't quite see how or why but when I even select an item on the list, close the form and return to it, the first item on the list is blank!

Luckily I made a copy of the list and keep having to fill in the first item... to get around that I have simply made a blank field as the first item in the list... but I just can't work out where it has come from or how to fix it?

I've tried removing the clear form coding but that has no effect - even restricting the list box from being editable and it still happens?!

Weird?

 

[boblarson]

Is the listbox's rowsource a table/query or a value list?

 

[Chrisopia]

its a table and query list which is why it's particularly bothering - deleting the first item from the actual table!? - although it keeps the ID number the same.

I cant find anything similar happening anywhere else on the internet!?

 

[boblarson]

I'm not sure what could be causing it either. Is there any chance of getting a copy of the db posted here so we can take a look?