Article ID: 141620
Article Last Modified on 1/19/2007
Find What: AddAllToList
Replace With: FillSelectProduct
Search: Current Procedure
' Open the recordset defined in the RowSource property.
Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset(ctl.RowSource, dbOpenSnapshot)
to read:
' Open the recordset defined in the RowSource property.
Set dbs = CurrentDb()
Dim qdf As QueryDef
Set qdf = dbs.QueryDefs(ctl.RowSource)
qdf.Parameters("Forms!EditProducts!SelectCategory") = _
Forms!EditProducts!SelectCategory
Set rst = qdf.OpenRecordset(dbOpenSnapshot)
NOTE: If your RowSource property uses an SQL statement instead of a
saved query object, you can replace the line above that reads
Set qdf = dbs.QueryDefs(ctl.RowSource)
to read:
Set qdf = dbs.CreateQueryDef("", ctl.RowSource)
Additional query words: too few parameters expected 1 2 3 4 5 6 7 8 9 0
Keywords: kberrmsg kbprb KB141620