hi got a slight problem here. this is a bit hard to write so work with me i have 3 combo boxes 2 of them "a and b" have select statements returning values from a sql table the third "c" needs to return values from the sql table based on the combo box b.

so when b is the same as the start of a concat code in the table return the code in line with the con cat code.

(this is what i think it should look like " select CC_CODE from CST_COSTCENTRE where CC_CONCAT_CODES "begins with" '" & CSTCODE & "'")(CSTCODE is the variable that uses what is selected in the combo box b.

i need to know how to do the "begins with" bit please help

thank you very much
have fun matthew allee

exact syntax depends on which database you are using and how you are calling it (ADO?), but in general you can do "begins with" by using LIKE along with whatever wildcard your db supports (generally %), example
... where CC_CONCAT_CODES LIKE '" & CSTCODE & "%'"

hth
Phil

Hi sorry thank you for your post i sorted it in the end i dropped into query analyser and plugged in all i could and wham exactly what you put nearly the code looked like this in the end "like '" & combo3.text & "%'" for those who need to know thank you very much for replying