Date selection via Form buttons

[Terry_C]

I am trying to run a query similar to the one mentioned by ivanteo earlier. I want to enter one of two fixed values, 14 or 31, into the criteria expression >=date()-"n" where "n" is 14 or 31. However, I want to do this from a form via two buttons which either select 14 days or 31 days worth of data. Can anyone help please?

Thanks

 

[anna the third]

Hi Terry,

You can use option groups. Create such a group with two option buttons. Give the buttons resp. the values 14 and 30.

To retrieve the value the user has chosen:

Me.OptionGroup.value

greetZ,
anna

 

[Terry_C]

Many thanks Anna - that's great

Terry