Table fields with unique future dates as drop down

  • Thread starter Thread starter Jennifer B.
  • Start date Start date
J

Jennifer B.

Hello:

I need to set up future date fields that are different (app. 50
different ones)for a drop down box in a form, i.e.: I have a date and
am looking for a response date 2 days in the future on ham from my
categories table. Another example: response date 10 days in the
future on bacon from my categories table. I would like the ability
for users to access a drop down box to choose the category, which
would then insert the corrent response date for that item.

I have searched endlessly for information on how to do this and am
getting quite frustrated.

Any help you can offer is GREATLT Appreciated.

Thank you,

Jennifer B.
 
I would add another field to your category table which would represent the number of days to add ([DaysOut]). Then, on your drop down properties of the category field, make sure you have the number of columns include the new field (you can set the width to zero so it is not seen).
Then, on the After Update event of your Category field use code similar to the following:

[NewDate] = DateAdd("d", [Category].Column(1), [OriginalDate])

In this formula [Category].Column(1) represents the second column in your drop down box (the column count starts at zero).

Hope this is what you needed.
 
I would add another field to your Category List table to represent the number of days to add. Then, with the Category combo box based on that table, add another column (for the new field) and set the width of the new column to zero (if you don’t want to see it). Then, on your Category field After Update event, put code similar to the following:

[NewDate]=DateAdd(“dâ€,[Category].Column(1),[OriginalDate])

In this formula Column(1) actually represents the second column of the combo box (the count starts at zero).

Hope this is what you needed.
 
I would add another field to your Category List table to represent the number of days to add. Then, with the Category combo box based on that table, add another column (for the new field) and set the width of the new column to zero (if you don’t want to see it). Then, on your Category field After Update event, put code similar to the following:

[NewDate]=DateAdd(“dâ€,[Category].Column(1),[OriginalDate])

In this formula Column(1) actually represents the second column of the combo box (the count starts at zero).

Hope this is what you needed.
 
Sorry about the above posts. I kept getting an error on the post... I am still trying to work through the new site.
 
Back
Top