Trigger not working

[#1]

Hello All,

I have a field named Plan_Week. I always want this to be selected as the lastest field in the filter. I have used Select in field trigger. I select the field as Plan_Week. Now when i try to enter manually the lastest week 2011W22 without quotes in the search string field, it works. when i try the formula maxstring(Plan_Week) in the search string, it does not work. It also does not work if i put quotes '' around 2011W22 like '2011W22'.

Can some one help how can i use the maxstring formula in the search string field for the select in field trigger

Arif

[spividori]

Hi.

In my case to arrive at a sheet, I have to select the maximum date.
For this use the following trigger:

DiasCrono is the name of the field where the dates are hosted.

sub MaxFechaCrono

ActiveDocument.Fields("DiasCrono").Clear

set f = ActiveDocument.GetField ("DiasCrono")

f.TopSelect "Max(DiasCrono)",1

end sub

Hope this help.

Otherwise you could upload your trigger to help you?

Regards.