I've set up a little program to aid me at work. I've used to know some of these things when I was still in school but off course they are now forgotten. I'm using an ordinary db connection using SQL statements to select the data. But now I need to remove a record and it comes with criteria. So I thought something like this should do the trick:

ssql = "delete * from order where titel = lblTest.Caption"

I do think that lblTest.Caption shouldn't be included within the " because it isn't a constant and neither a string.
And after setting the SQL statement I then execute it.

rs.Open ssql, madoCon, adOpenStatic

I hope this is enough information to help me a little bit forward cause I really am looking forward to using this program at work.
Anyhow Thx for any hints or solutions.