SQL Satement error

[daveStudent]

I'm trying to run the following statement

Cmd = "SELECT * FROM Cabinets WHERE CabinetName = '" & txtServerCabinet.Text & "'"

DsAll1.Cabinets.Select(Cmd)

and im getting a missing operand after Cabinets error

Cabinets is the table, and im searching for the string in txtServerCabinet

then im trying to display the appropriate item in text boxes

any idea whats wrong?

db