Hi All,

I am trying to access a layout based on calculation result. Actually I have app 50 layouts and I want to access them based on users name and few other conditions which I have stored in calcualtion field and have named layout names in that way. Is there any way, I can access layout like "Go to Layout(Layoutname)" where Layoutname is a field not selected from drop down list.

Thanks in advance

Aditya

You can use the script step Go to Layout(LayoutNumber) which is the next to last option for this script step. Regardless of what you named the layout, they have a number associated to them by the order they are listed in when you are in Layout Mode. Go to the Set Layout Order dialog box and you can put the layouts in any order. If your script step says go to layout #4, the fourth layout in the list is what will appear.

HTH, Mike

You can get the list of layouts in proper order with the design function layoutnames(status(currentdatabase)). You could use that for a dropdown list , or query that list (for the position (patternCount(Middle(layoutnames, 1,Position(layoutnames, mylayoutname,1,1))," ")