Combo Box / option buttons to set variables for a date

[CiaranP]

Hi,



I'm looking to have either a combo box,, or 2 options buttons (whichever is easiest) that set a date field based on what is selected in the combo box/ option buttons.

The variables are 'Payment in 30 days" " Payment upfront"

if "payment in 30 days" is selected the date field on the form will enter the date as + 30 days from todays date
if "payment upfront" is selected the field on the form will enter todays date.

This date field must be blank unless an option is selected, as this information is only entered in a later stage of the form.

I've tried a few different ways to enter this but i can't quite get it to work as i want.
I hope someone can help me with this.

Thanks.

Ciaran

[CJ_London]

you could put the following in the combobox afterupdate event

select case mycombo
    case "Payment in 30 days"
        mydate=dateadd("d",30,date())
    case " Payment upfront"
        mydate=date()
    case else
        mydate=null
end select

[CiaranP]

Thank you!

Had to add 2 more cases but that is spot on. Thanks again for your response