Hello to all,
I set up a form that includes a table with four rows. In this table, which is displayed with tab-folders, an embedded view was added in the second row.
The view should show different documents depending on the content of a special field of the form. This field is set up in the first row of the table.
In detail, the first tab-folder lists the adress information of a company, the second folder should show the contacts to this company in a view.
The following code was added to the “initialize” section of the view:
Dim ws As New NotesUIWorkspace
Dim session As New NotesSession
Dim db As NotesDatabase
Dim uiDocument As NotesUIDocument
Dim view As NotesView
Dim formula As String
Set uidocument=ws.CurrentDocument
Set db = session.CurrentDatabase
Set view = db.GetView( “contact” )
Company=uiDocument.FieldGetText(“CompanyName”)
Formular =“contact”
formula = “SELECT ((Form = '”+Formular+“')) & (@Contains(ContactCompany; '”+Company+“'))”
view.SelectionFormula = formula
view.Refresh
The selection formula is computed in the right way and is saved to the view.
But there is no change in the entries showed by the view when I open different documents.
Where am I wrong ? I didn’t find any help in documentations - where do I have to look up ?
Thanks for your help in advance !
Ulli