Automatically setting a due date using MS Access

[PERIOD], [FREQUENCY] and [DATE RECORDED] are all referencing fields on the form, where; PERIOD = ("d", "ww", "m" or "yyyy"), FREQUENCY = (1-11) and DATE RECORDED = Now().

For some reason the tasks are no longer recording on the table that the form is linked to. I was looking for the form to open from a home-screen command button, which seems to work, then the data can be entered and on clicking the "Add Task" command button the record would be added to the table, the form would move to a new record, then close. To do this I embedded a macro (image below). Can you see any issues that may account for the issue in adding records. I can't really check whether any changes to the DateAdd() Function are effective till the records are showing in the table.



Thanks

Ok, I just created a form with a text box. In the text box I manually placed the following:

=weekdayname (weekday (dateadd ("d",1, Now ())))) & ", "& dateadd ("d",1, now ())

This produces an output of Wednesday, 7/25/2018 and a time stamp. Get an ouput to display something, then we can toil with the variables.

You have to link the variable to the table. So you must use the syntax of:

[table].[field]

The reason to do this is because you may have a BUILT IN QUERY that returns the number of RED Cars into a value called [cars]. In this case, [cars] could also be a field in a table, so you must reference the name of the query/table. So if the query was called [countingcars], the variable would be initialized as:

intCars = [countingcars].[cars]

You may need to initialize a variable with the values stored in the DB. So instead of linking the formula to the DB value, use a crosswalk and do something like:

in a sub of FORM_OPEN():

intValue = [table].[period]

Then use:

weekdayname (weekday (dateadd ("d",intValue, Now ())))) & ", "& dateadd ("d",1, now ())