I am seeking to retrieve a record from a listbox where I may edit the entire record. I am not sure what the syntax is for doing this where I am using the key value of the recordset as the lookup value. Using DAO it would be the same as:

Code:
rsTable.index = "PrimaryKey"
rsTable.Seek "=", keyValue
What is the syntax for retrieving a record using ADO?

Thanks,
Blake