creating recordset vba wit sql statement
i am perplexing emanate recordset opening vba arrangement me annals list associated tide record form. tide formula looks this:
private servant form_load()
low rst recordset
set rst = currentdb.openrecordset("select [id], [ln] [order detail] where ((([order detail].[id]) = [forms]![order information opening header]![id]))")
rst.movelast
forms![order information opening header].linenum = rst![ln]
end sub
i am doing adding new annals numbered sequentially after top number. i run form "run-time error: '3061' too few parameters. approaching 1." set rst line.
any assistance appreciated.
Comments
Post a Comment