I am using the following code to open and update a recordset selected in a form:
Private Sub SaveButton_Click()
dim rst as Recordset
set rst=CurrentDb.OpenRecordset(" select * from tblSubCO where SubCOID="& txtSubCOID)
'update selected records from entries
'set field values here
I get a "to few parameters; expected 1" errror. I tried using db.QueryDefs but I don't think I was getting that right. I'm not very good at this sort of thing.