Question for ADO control(VB6) TellMe1232004-01-16 00:32:00

I have a ADO control on a form. It's connected to a Access table. Now ADO control's Recordsource, we can type a table name or a SQL statement. If I type a sql statement like

Select *from table where ID = myValue

But it doesn't work, I tried many different ways to put "my Value" or "& myvalue &", nothing worked. Can anyone help? myValue is dynamic and from input.

Thanks.



--文学城www.wenxuecity.com--

Question for ADO control(VB6)