Reading the array number from a combo box

[rickyoswald]

How do I read the currently selected array number of a combo box? i.e. if I have the 4th item selected the array value would be '3'. I thought it was cboBox(x)... but have been told to use cboBox.item(x) however the only property I can find similar to that is .itemdata (which does not work).

 

[mmilan]

Always - Always, Always ALWAYS check (rs.eof and rs.bof) when moving the record pointer...

And yes, delete will move the record pointer. As will opening a recordset...

mmilan.

 

[rickyoswald]

Okay Mmilan I think you are onto somthing. I have to tidy up my code. I'll get on it tommorow (18th birthday stuff right now).