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

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members