Peekaboo Fields

[mKirk]

Okay...I've tried everything my newbie brain can think of. I need a script that I can attach to a button to do the following:

Button is placed in "Layout A". When this button is clicked, needed script looks at "Field1" in "LayoutA". If "Field1" isEmpty then "Field2" in "LayoutB" (not a typo, a seperate Layout) is set so it can not be entered in Browse mode...effectively making it hidden. Finally we go to "LayoutB" (don't need help with that part!)

Of course the opposite would also be true, that is if "Field1" not isEmpty then "Field2" would remain visible/enterable. Any suggestions would be appreciated.

Thanks in advance.

[comment]

Here is the simplest way:

Enter layout mode. Duplicate LayoutB. Rename the new layout LayoutC. Remove Field2 from LayoutC.

Make the script:

If [ IsEmpty ( Field1 ) ]

Go to Layout [ LayoutC ]

Else

Go to Layout [ LayoutB ]

End If

[mKirk]

Actually, overnight I had just thought of doing basically what you are suggesting. However, in the actual thing I'm working on this would mean I'd have to create 15 different layouts to cover all of the possibilities. I was hoping that there was a way to achieve this more dynamically using LayoutA as the "Template Builder" so to speak, with LayoutB being the result.

[comment]

Another option could be the portal visibility technique - go to http://www.databasepros.com/resources.html and do a search for 'visibility' to learn more.

[mKirk]

Will do...thanks for the link.