How to dynamically set selection values in listboxes "on open" of document based on userid

[#1]

Dear Community,

We've a requirement: based on the userid who opens the QVW we would like to

1. retrieve the job he does via  Lookup from a resident table

2. set the jobtype into a parameter

3. and set the job as a selection

when opening the document so "on open" of the document.

any ideas would be welcome...

cheers

SB

[Mark_Little]

HI,

Have you look at sections access?

Another option would be to make a Trigger OnOpen, but it could be a complicated if statement, to get the right fields.

Like if(OSUSer() = 'A', 'BO'

          if(OSUSer() = 'B'

Maybe have bookmarks that have the selection your want and then you can use the above if idea to apply the the right bookmark on open?

Mark