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