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 hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?