I'm using Vb.Net and odbc Server
I have a Listbox that users can select multiple values. Selection Mode =
Multiple.
The multiple values are associated with one record. I need to insert into
the database like this:

Erik San Diego
Erik San Francisco
Erik Sacramento

How can I find out what the selection value is if they picked more than one.

Thanks.

Hi friend

Please tell me why this error is occured

ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 22.

Cod

Dim InsertString As String = "INSERT INTO TableHR1 VALUES(@No,@nam e_of_candidate, @Address,@Date_ of_birth,@Phone No,@Email,@Desi gn_Eng,@CAE_Eng ,@Mkt,@Accounti ng,@It,@Admin,@ Experience,@Ind ustry,@Current_ CTC,@InHand,@Ex pectedCTC,@Exp_ Inhand,@Joining _Period,@Iziel_ Result,@Iziel_R emark,@Candidat e_Remark)...

Hi friend
Please tell me why this error is occured in following code

error=ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.




...