Tim Thiessen
tim at irwin-greenhouses.com
Fri Jun 6 10:59:31 CDT 2003
Dear Group,
Can anyone tell me what I am doing wrong here? When I run this as a stand
alone query, it runs fine but when its in the form as code, I get the error
message "Run-time error 3061 Too few parameters. Expected 1"
sqlWSName = "SELECT DISTINCT qryInvItemWrkSht.worksheet, " _
& "qryInvItemWrkSht.worksheet_desc " _
& "FROM qryWrkSht INNER JOIN qryInvItemWrkSht " _
& "ON qryWrkSht.[Item Number] = qryInvItemWrkSht.Item;"
Set rstWSName = CurDb.OpenRecordset(sqlWSName)
TIA,
Tim Thiessen