I have a doucment which when composed creates a drop down dynamically taking values from a column in a view from another database.
I also have another button next to this field which when clicked should take the value selected from the drop down and search another databse view for a document to match this value and then open it. But it doesnt work ..
Sub Click(Source As Button)
Dim session As New NotesSession
Dim workspace As notesuiworkspace
Dim db As NotesDatabase
Dim view As NotesView
Dim uidoc As notesuidocument
Dim doc As NotesDocument
Dim product As String
Set db = New NotesDatabase( "server", "prductlist.nsf" )
Messagebox db.IsOpen (it returns falsoe here )
Set view = db.GetView( "prodbydesign" )
Messagebox view.Name ( Again error saying that database is not open)
Set uidoc = workspace.CurrentDocument
product = uidoc.FieldGetText( "odesref" )
Set doc = view.GetDocumentByKey(product)
I NASICALLY JUST NEED THIS DOCUMENT TO OPEN WHEN USERS NEED TO SEE THE DOCUMENT..I DONT MIND OPENING IT IN EDIT MODE BUT WOULD PREFER TO OPEN IT IN NON-EDIT MODE
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!