currentdb.execute won't run query
Posted on 2000-04-27
I have an update query that computes fields from unbound controls on an open form:
UPDATE NoticeTemp SET NoticeTemp.Appt = ([Forms]![frmLtrAppt]![grpDateByOrOn]=1), NoticeTemp.TickleType = [Forms]![frmLtrAppt]![grpInterviewType], NoticeTemp.EncloseForms = ([Forms]![frmLtrAppt]![chkEncloseForms]=-1)
The update works fine using docmd.openquery (so long as I setwarnings off), but when I use currentdb.execute I get error #3061 "Too few parameters, expected 3.
Why? Would it work if I referred to the controls using different syntax? Does it matter? Would it be more efficient to update the records in code, by stepping through the recordset? I usually figure Access's native implementation of a query is more efficient than anything I do, but maybe this is an exception.