Has anyone come across a solution for this type of issue? I created a lookup/record select form that goes against a remote Oracle Database, basically listing members. I have the underlying cursor begin empty, then when they enter the criteria they are looking for, I dynamically build a WHERE clause I want to run against the back end. However, when you resubmit the query, it closes and reopens the cursor and the grid then loses it's RecordSource and goes completely blank. The cursor has the correct set of data, but simply resetting the RecordSource isn't good enough because I've lost all the formatting/captions/etc.
The only thing that immediately comes to mind is releasing and re-adding the grid object on the fly. Is there an easier way?
I can't get away with a parameterized query since the # of items in the WHERE clause varies.
The only thing that immediately comes to mind is releasing and re-adding the grid object on the fly. Is there an easier way?
I can't get away with a parameterized query since the # of items in the WHERE clause varies.