Item Turnover Form (158)

Savatage

I have a question & I just can't seem to figure it out. ](*,)

The item period for this form can scroll up & down endlessly.

Needless to say I don't need it to go to year 1784 for example.

How can I change this range so it only shows 1/1/2000 to say 12/31/2010?

Thanks

alanperu

Hi Savatage,

The Item Turnover lines are on a subform, and there is no link to the subform in the parent form's properties - just a sub form name. I just tested it by adding a link to this too. If you add a subform link of:

Period Start=FILTER(01/01/00..31/12/10)

it seems to do what you want.

NB - these are UK dates!

Is this what you need?

Savatage

YOU ROCK! 8)