I have a combo box being loaded with the 'id' field from my database. (id is autonumber prim key)

I'm displaying the data in the db with textboxes linked to columns of my db

When i select a diff id from the combobox i want the data in the textboxes to change accordingly.

i think this is the correct sql string, but other than that i dont have a thing

mySQL = "SELECT * FROM Bottle WHERE id = " & cbID.selectedItem

anything at all would be great

thx

db