Form object not storing data into field of table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The form I have has multiple date fields.
Event date, 3 Month Follow Due Date, 3 Month Acutal meeting date, 6 Month
Meeting Due Date, 6 Month Actual Meeting date.

I have the 3 month and 6 month follow up date fields auto-populate from the
Event date field using the following =DateAdd("m",3,[Event Date]) and
=DateAdd("m",6,[Event Date]). That part of it works fine, but that dates
that are being automatically being populated are not being stored in their
fields in the table.

Thank you in advance.
 
Firstly, they are calculated so you do not want them stored back to the
table.

If you do, change the control source on the form to be the [3 Month Follow
Due Date] etc fields rather than an expression. Then, on the after update
event of the EventDate field do the following

Me![3 Month Follow Due Date] = DateAdd("m",3,[Event Date])
etc.
 
Thank you for your advice.

JohnFol said:
Firstly, they are calculated so you do not want them stored back to the
table.

If you do, change the control source on the form to be the [3 Month Follow
Due Date] etc fields rather than an expression. Then, on the after update
event of the EventDate field do the following

Me![3 Month Follow Due Date] = DateAdd("m",3,[Event Date])
etc.




Michael S. said:
The form I have has multiple date fields.
Event date, 3 Month Follow Due Date, 3 Month Acutal meeting date, 6 Month
Meeting Due Date, 6 Month Actual Meeting date.

I have the 3 month and 6 month follow up date fields auto-populate from
the
Event date field using the following =DateAdd("m",3,[Event Date]) and
=DateAdd("m",6,[Event Date]). That part of it works fine, but that dates
that are being automatically being populated are not being stored in their
fields in the table.

Thank you in advance.
Click to expand...
Click to expand...
 
I can't get that syntax to work. Can you please explain in more detail how
and where to enter that code?

Michael S. said:
Thank you for your advice.

JohnFol said:
Firstly, they are calculated so you do not want them stored back to the
table.

If you do, change the control source on the form to be the [3 Month Follow
Due Date] etc fields rather than an expression. Then, on the after update
event of the EventDate field do the following

Me![3 Month Follow Due Date] = DateAdd("m",3,[Event Date])
etc.




Michael S. said:
The form I have has multiple date fields.
Event date, 3 Month Follow Due Date, 3 Month Acutal meeting date, 6 Month
Meeting Due Date, 6 Month Actual Meeting date.

I have the 3 month and 6 month follow up date fields auto-populate from
the
Event date field using the following =DateAdd("m",3,[Event Date]) and
=DateAdd("m",6,[Event Date]). That part of it works fine, but that dates
that are being automatically being populated are not being stored in their
fields in the table.

Thank you in advance.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top