The error message I'm getting is Data type mismatch in criteria expression.
My coding is below:
SQL = "SELECT ExName FROM VirtualLearningExercises WHERE VirtualLearningExercises.Level = '" & UserLevel & "' ORDER BY ExName" Da = New OleDb.OleDbDataAdapter(SQL, Con) Da.Fill(Ds2, "ExerciseNames")
The error is coming up when i'm filling the dataset, i've already figured that it works when the WHERE is removed. So i'm assuming the mismatch must be from (VirtualLearningExercises.Level = '" & UserLevel). UserLevel is defined as a integer in vb and VirtualLearningExercises.Level is data type number on access. So i'm pretty confused why it's occuring.
Thanks in advance for any help.