Date Fields

[wali60]

Hi Everyone, Thanks for any help in advance.
I'm not sure of this but here goes.
I have 2 fields, Date Issued and Next Available Date.
Date Issued is the current date (usually a Thursday or Saturday)

Next Available Date needs to calculate the date 2 months from the Date Issued field and enter the result in the Next Available Date field.

I have tried this in the Next Available Date field =[Date Issued] + 60 but it doesn't work.


It seems to be a pretty simple thing but I'm tearing out whats left of my hair.
The DB is for a non profit group supplying food hampers to those in need and the 2 month is the next date the client can be helped.

[pkstormy]

Is this: =[Date Issued] + 60

in the ControlSource for the field?

If so, it won't work if you're trying to actually save to the [Next Available Date] field. You'll need to put this in vba code for some event (ie. AfterUpdate of some field) as something like me.[Next Available Date].value = [Date Issued] + 60. Note though that you need to trigger this code on some event. This could be something such as the OnCurrent or OnOpen event of the form so that it gets updated whenever that record is opened. (also note: if updating a value in a field on a form's event (ie. such as the OnCurrent event), you should also issue a 'Refresh' command in code after updating the field. Otherwise you can get 'write conflict type' errors, especially if that field is also being updated on the form itself.)