passing variable in sql error(pls help)

[PinoyDev]

good day!

I want to pass the value that contains tha table name and load its data.But my sql turns error.Below is my code.

Combo2.Text = "first_year"

sql = "select * from " & Combo2.Text & "'"
        rs.Open sql, conn, adOpenKeyset, adLockOptimistic, adCmdText

Im using mysql as backend database.

Pls help.God bless on this mother earth.

Thank you for your time.!

[vb5prgrmr]

sql = "select * from " & Combo2.Text & "'"

You don't need tick on the end.

Good Luck

[PinoyDev]

sql = "select * from " & Combo2.Text & "'"

You don't need tick on the end.

Good Luck

thank you sir. This problem was solved.