Hi, I am new to VB database programming, and i have a question.

I use ADO, the connectionstring is OK, on the RecordSource , I choose 1_adCmdtext, then I input a SQL , such as
"select * from Person where person.ssn=S_ssn"
, it do not work,
here, S_ssn is a public variable, and I also tried such as "select * from person where person.ssn= "'&S_ssn'" "
, or something like that. it totally don't work. When I put a value("111111111") intead of a S_ssn, it works.

I want to know How to use a public variable on the Recordsource choice.

Any Suggestions are welcome!
velle