Using checkboxes for calculations

[matey56]

Hi,


I have a form with a control that does a simple calculation by adding 18 months to a date in another control. Now I want to give the users the option to check a box for either 12 or 18 months. So depending on which box is checked, the control will add either 12 or 18 months. What's the best way to handle this?

The formula is currently in the control is: =IIf(IsDate([Date_Driving_18_Month_Expiration]),DateAdd("m",18,[Date_Driving_18_Month_Expiration]),"")

[Micron]

I would use an option frame with 2 option buttons. Option labels indicate the value. The chosen option is passed to the frame. The best benefit to this is that if you want to add other values later, you will only have to add options and not change your expression (calculation formula) because the chosen value is always passed to the frame. This is better than one checkbox, which can be checked or not (thus only providing 2 possible values) except where it has never been checked. In that case, it is neither and you would also have to deal with that.

BTW, the moment you want to pass a variable value to the expression, any solution will have to be handled in code.

[ssanfu]

Another option would be a 2 field table (NumMonths, txtDescription) and a combo box.

NumMonths	txtDescription
12	12 Months
18	18 Months

To add more options, just add to the table.