how to filter in a form

[J_jvs]

    How can I filter in a form?

I want that when I'm selecting in estat, "Magatzem"

only appears in subestat: "mecanitzat" and "pintant"

thks in advance

JVS

[Izzat_Safrah]

Go to column [SUBESTAT] and use this function in Vaild If 

IF( [ESTAT]= "Magatzem" ,

{ "mecanitzat" , "pintant" } , True )

[J_jvs]

Hi Izzat, thks but

appears this error message

"IF function is used incorrectly:the second input (value-if-true) and third input (value-if-false) should have the same type."

[Izzat_Safrah · Accepted solution]

  Try this without True

IF( [ESTAT]= "Magatzem" ,

{ "mecanitzat" , "pintant" } ,

{ "mecanitzat" , "pintant" , "comprat" } )

[J_jvs]

Izzat, thks a lot for your help!

[Izzat_Safrah]

You are welcome.