mfischer2
asked on
Filters - easy question (need quick answer)
I am just missing something here I think, but I am trying to
run a filter on a table. Heres the background, the user selects customers from a multi-pick list, these are then read into a table. That part works.
I then have a query that joins on the customer name to a table with customer data, and returns all the customer data, in effect only showing data about selected customers. This is what my code does...
'DoCmd.OpenQuery "filtertest", acViewNormal, acEdit
DoCmd.OpenTable "RespondentList", acViewNormal, acEdit
DoCmd.SelectObject acTable, "RespondentList", False
DoCmd.ApplyFilter "filtertest"
on this last line (filtertest is the query mentioned above) I get an error Runtime error 2488, says that I have not selected a table to perform the query on. And mentions that I should use SelectObject, which I do, but no to avail. I need this answered pretty fast...
thanks, Matt Fischer
run a filter on a table. Heres the background, the user selects customers from a multi-pick list, these are then read into a table. That part works.
I then have a query that joins on the customer name to a table with customer data, and returns all the customer data, in effect only showing data about selected customers. This is what my code does...
'DoCmd.OpenQuery "filtertest", acViewNormal, acEdit
DoCmd.OpenTable "RespondentList", acViewNormal, acEdit
DoCmd.SelectObject acTable, "RespondentList", False
DoCmd.ApplyFilter "filtertest"
on this last line (filtertest is the query mentioned above) I get an error Runtime error 2488, says that I have not selected a table to perform the query on. And mentions that I should use SelectObject, which I do, but no to avail. I need this answered pretty fast...
thanks, Matt Fischer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER