Change tab based on field contents

[Jeffryjon]

I'm a newbie so please forgive this question. I have looked through all the threads on this but so far haven't found something that works.

I have a field with a drop-down menu which I want to use to show/hide fields

let's say the field is called select_tab with drop-down selections of A, B, C, D.

In my tabs I have tabs A, B, C, D, E respectively.

If I understand correctly, tab E (not being on the menu of select_tab) is to be used as the default tab and left with no contents.

Tabs A, B ,C, D all have some fields which I want to display ONLY if the corresponding letter is selected in select_tab

Having messed around with all the scripts I've found on the threads, I still can't get any that work (FM10 pro adv)

If anyone could help, would be much appreciated, J

[comment]

See if this helps:

SelectTab.zip

[Jeffryjon]

I can't thank you enough for this - fantastic. Thanks again.

[Jeffryjon]

Just an update to this. Your file example works great but when I tried using it in my file I struggled to get it to work. I found another way that I should have figured before. The script is a bit longer and there was more work but anyway it works just fine.

First make a value list with A, B, C, D, E

Then make sure your tabs are named with corresponding names (A thru E)

Then set Tab E as the default

Then use an If fieldname = "A" statement followed by a Goto Object "A"

Else if fieldname = "B" followed by a Goto Object "B" etc etc until you reach the end of your choices

The last choice is Else if fieldname = "E" followed by Goto "E" in this case

Before the end if statement I placed an IsEmpty (fieldname) followed by Goto Object "E" as a safeguard. That covers accidental deletion and a new record with an empty field.

Anyway, still a big thanks for the example you showed me.