Displaying 'deadline' dates depending on the activity

EmmaR

New member
Local time
Yesterday, 16:02
Joined
Feb 1, 2008
Messages
3
Not really sure how to word this as I'm not sure if I even understand.
Basically I have been asked to set up a database logging distubances and need to display on the form 3 different dates (action by, monitoring period and date to close case) from the date the data is entered, depending on the disturbance chosen.

So if there was noise nuisance the action date would be 7 days, the monitoring period would be 14 days and the closing date would be 90 days. This would be different from, say dog fouling. When the user chooses the disturbance from the combo box I need the dates to reflect the deadlines for that disturbance.

I have entered the number of days to add onto the table containing the disturbances (ie 7, 14 etc) and know how to add these days onto the original date.

How do I make this happen depending on the disturbance selecting.:confused:

Hopefully someone can help!
 
Use a combo box to choose the disturbance type. Include in the combo the three periods but set the column widths to zero so they are not visible to the user. You can then use the column property of the combo to select the appropriate value for your calculation.
 
I've made the ComboBox with the three periods, but I still don't understand how to display the calculated dates.
I'm self taught pretty much and need more instructions!
Thanks for your help so far.
Emma
 
In the data source of a text box on your form, you need something like this:

=DateAdd("d", MyCombo.Column(2),txtEntryDate)
 
Can I just point out to Emma that the Column(index) starts at 0 for the first column in the combo box. It's in keeping with all indexing but not nescessarily obvious to a newbie.

Brian
 

Users who are viewing this thread

Back
Top Bottom