Help needed

[Andy]

Two questions in one

1 I have used a cntrl source to add to years to a date entered into a form.
It works great but dosnt appear to update the table, which then leaves no
output on the reports. What did I get wrong this time.

2 I have 3 fields on a table for training courses the fields are check box
as a simple yes/no. Course Date and Course Renewal Date which is where
question 1 comes in. I would like to add a new field for course status. So if
Course Date is empty the "Not Required" would show in the form table and
report. Once a date is entered in Course Date and auto updates Course Renew
Date I would like to change from "Not Required" to "Current" if the date you
are looking at the data is after the Course Renew date it would need to
change again to "Expired".

Can this be done ?? If yes how ?? If No just say so ??

Thanks in advance.

 

[Beetle]

1 I have used a cntrl source to add to years to a date entered into a form.

It works great but dosnt appear to update the table, which then leaves no
output on the reports. What did I get wrong this time.

Create a query based on the table. Add a calculated field to the query using
the same formula you are currently using to calculate the renewal date. As
this
is a calculated value, it should not be stored in the table anyway.

As for the second part of your question, add another field to the
afforementioned query that would be something like;

Status: IIf(IsNull([Course Date]),'Not Required',IIf(Date()>[Course Renewal
Date],'Expired','Current'))

Again, as this is basically a calculated value, it would not be stored in
the table.

Then you use the query as the recordsource of your form/report. The control
in your form where you are currently doing the calculation would then use the
calculated query field as it's control source.