[AccessD] A2002: DateAdd From a Combo box

How about a hidden column in the combo box with a sequence number and when
the user selects one from the combo box, in the after update event put a
Select Case and run the Date Add that you want?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren
Sent: Tuesday, November 27, 2012 3:08 PM
To: AccessD
Subject: [AccessD] A2002: DateAdd From a Combo box

Hi Y'all

I am storing some DateAdd functions in a 2 column table to give users a list
of choices for automatically creating a new "next due date"
Values in the table look like this

DateAddDescription   DateAddvalue
-----------------------------------------------------
Every Day                     DateAdd("d",1,NextDueDate)
Every Week                  DateAdd("d",7,NextDueDate)
Every Month                DateAdd("m",1,NextDueDate)
Every 3 Months           DateAdd("m",3,NextDueDate)
Every 6 Months           DateAdd("m",6,NextDueDate)

When a user selects one of these items from the combo I'd like the actual
Date Add function selected, to be applied to the actual "next due date" on
the form Assume the "next due date" is blank in a new record, once a user
selects a value from the combo, say....the 4th one
      DateAdd("m",1,NextDueDate)
I'd like the new due date on the form to be "2013-2-28"
Make sense?
Many thanks in advance
Darren

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com