How do I make view selection context sensitive?
Posted on 2004-04-21
I have a database which contains two identical views except for the "View Selection" formula. One view shows all documents, the other shows a subset of the documents. The user opens views using an outline which points to each of the two different views.
My problem is that everytime I make a change to this view I have to make it twice, once to each view (note: while not a problem in my simplified case above, the reality is that I have dozens of views so it is a lot of work to update all views). What I want to be able to do is create one view and then somehow pass a parameter to the view based upon how it is opened which can then be used to modify the "View Selection" formula based upon which outline entry was used to open it.
If you're familiar with VBA in Access, I'm looking for something similar to the OpenArgs parameter that I use all the time to modify the SQL expression used to create the record source for a form.