>Hi Everybody,
>
>I have this:
>
My_Conn = CreateObject("ADODB.Connection")
>My_Conn.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Data\MyDB.mdb")
>MY_Conn.Execute("Update My_Table set ReNo = ?")
>
>What should I use instead of ? to assign the record number to RecNo field in My_Table?
>
>Thanks,
>Ali
? is correct. However instead of MY_Conn.Execute, use ADODB.Command and add parameter. Search for ADO updating with parameters samples here.
Cetin