Clear some field on another field selection!!

[#1]

Hi all,

can i clear only two specific Fields on any selection of another Field?

Example:

i have this field in selection: Year,Month,Product,City

Initially the current selection is: 2012,March,4S, Tokio

Every one i select another City, i want to clear only Product and Month.

Is possible do it without a button?

Can I do it with or without a Macro?

Can you help me?

Thank You All

MC

[MayilVahanan · Accepted solution]

HI

Use trigger

Document properties->trigger ->

Select:

City

Onchange or OnSelect ->

Action:

Selection ->Select in field

Field:

Month

Searchstring:

=''

by same way for product

Hope it helps