OnOpen Select ListBox value

[#1]

I have 2 list boxes that are loaded with data from an excel spreadsheet. 1 listbox uses field FiscalYear and The other uses FiscalPeriod. I also have written a query returning 2 fields from a database ReportYear and ReportMonth. 1 listbox contains all of the years from the spreadsheet and the other contains the months. What I want to do is have the default value in each listbox set to whatever value my query returns.

I have tried adding an OnOpen trigger in the document properties, but could not get that to work. Not sure if I am doing it wrong or if this is the wrong place to do this.

Here is what I have done Settings->Document Properties->Triggers

Added Select in Field action OnOpen

Choose field FiscalYear

added expression = Fields("ReportYear")

[#2]

hi ivan_cruz,

i am trying to make default selection of filed value as one always, but when i try to select the always select one value its, that option itself is disable.

Please help i need it urgently,

thanks in advance.