Database Problem

Question

Hi, Im using an access database to store a bunch of measurements. I have a dropdown menu so the user can pick measurements of an object then I assign these measurements to variables and then compare these measurements to the measurements stored in the database. From the database I am trying to retrieve a part number from the measurements the user has picked. The code does not work but I dont know why. The variables are picture,Number,and pictureCenter. Picture and pictureCenter do not keep pictures but the measurements. The columns in the database are HoseSize, FittingType, FittingSize conn.Open() AdaptID = New OleDbDataAdapter("Select PartNumber from TableID where " + CStr(picture) + " = FittingType and " + CStr(Number) + " = FittingSize and " + CStr(pictureCenter) + " = HoseSize", conn) AdaptID.Fill(TablePartNum) PartNumber = (TablePartNum.Rows(0)("PartNumber")).ToString() Label3.Text = "Left Part #: " + Partleft TablePartNum = Nothing AdaptID = Nothing conn.Dispose() thank you