Annoying problem.

[nicola1]

Basically i have a form which logs error corrections. The users enter a 'date received'. My user has now asked to have a date due to automatically be calculated by adding six days. I have done this with no problem:

=DateAdd("y", +6, [date received])

My form is not unbound, this date due field is the only unbound field i have. This date does not need to be saved in the table, just to appear when the user opens the form, which it does.

The problem which i am having is that i have a report which runs of a query, printing out the error correction, when the user types in the auto number required. The records added after i put the date due field, will not print out and when i run the query and type in the auto number of these records they do not appear...yet they are stored in the table. Obviously this is due to the 'date due' field, but im not sure how.

I really don't understand what is wrong. Could someone please give me an insight into what maybe wrong or tell me what to search for in the forum, because the searches i have tried have not come up with anything.

Thank you

 

[RuralGuy]

Though your code will work until the last week in December, I probably would have used:
=DateAdd("d", 6, [date received])

As for the report problem, I don't quite understand what you have done. Did you add another calculated field to the query?

The records added after i put the date due field, will not print out...

Where did you add the DateDue field?