>>My other problem is that I want the top combos to act as a filter. I am not sure about best method to filter the grid's recordsource based on the selections I made.
>>
>>I'm trying to use SET FILTER expression, but it looks like I have to define my filter as a character and use
>>set filter to &lcFilter
>>
>>Am I right?
>
>Yes,
>That is better, if you do not want to use "save" select or parametrized CA/View :-)
No, can not use it here, since rsHolds is already a cursor obtained by SQL Pass Through and made updatable.
If it's not broken, fix it until it is.
My Blog