How do I make a sheet appear when I make a selection?

[#1]

Hi

I want to know how I can show and activate a sheet as soon as I click on a value in either a list box or a table. I have a list of names in a table and I have created a sheet showing a detailed view of that person. I don't want to show the sheet but hide it and only open it if and only if someone clicks on a name in my table or list box.

Thanks

Rajesh

[#2]

Hi,

Go to sheet properties

General-------> Show sheet------>Conditional

Put the condition as per the values in the list box

Thanks & Regards

Upendra

[#3]

General-------> Show sheet------>Conditional

if(len(GetFieldSelections(namefiled))<>0,1,0)

bye

[jagan]

Hi,

Go to sheet properties

General-------> Show sheet------>Conditional

Use the following expression

If(GetSelectedCount(FieldName) > 0, 1, 0)

Hope this helps you.

Regards,

Jagan.