Hi Guys!
I need to know if there is a way the user is prompted what docs to display when a view is opened. It is somewhat a view whose docs to display are based on user entry(programmed prompt - e.g. start date to end date). Where can that be specified in the Domino designer?
Subject: Prompt user what to display when a view Opens
I tried:
Dim ws As New NotesUIWorkspace
Dim uiview As NotesUIView
Dim view As NotesView
Dim formula As String
formula = "SELECT Form= ""eSdoc1"" & eSCRDocCatL =""FPS"""
'that should be read as (Select Form="eSdoc1" & eSCRDoccatL="FPS")
'is it correct?
set uiview = ws.CurrentView
Set view = uiview.View
view.SelectionFormula = formula
The view does not refresh w/ the new selection formula. What do you think is the problem?
Subject: Prompt user what to display when a view Opens
Yes, take a look at the NotesView class, where in you could modify the view selection formula at runtime ( this is new with R6 ). You can also create columns at runtime based on the users selection.
Views till R5 were pre-defined queries, very rigid and such a requirement would always end up in creating a Search Form.
With R6 this should be a matter of minutes 
cheers !!
Ashish