Select same values from 2 non-associated listboxes simultaneously

[sifatnabil]

Hi all,

I have 2 date fields from 2 completely non-associated tables, "date1" and "date2". I want auto-select the same date2 value as the one I select from the date1 listbox, e.g. selecting date1=1/7/2014 should auto-select date2=1/7/2014.

I can edit the listbox into an expression like "date1 & ' ' & date2", however this is unsightly because it just says the same date twice. Is there any other way to do this?

[Anonymous]

You can use "On Select" Field Event Trigger from Document properities to achieve this.

[MK_QSL · Accepted solution]

Consider that you have two dates

Date1 and Date2

Settings >> Document Properties >>  Triggers

Field Event Triggers

Select Date1

OnSelect - Add Action

Add >> Selection >> Select in Field

Field

Date2

Search String

=Date1

Do the same procedure for Date2

[ashfaq_haseeb]

Hi,

Look at the attached application.

Regards

ASHFAQ