Filters - easy question (need quick answer)
Posted on 1997-07-29
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
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