I have the following line of code in the form_Current event of my main database form.
Me.[FollowUpDate].Value = Me.[QuoteDate] + (8 - Me.Text70)
The value in Text70 is calculated using the formula =DatePart("w",[QuoteDate],2) which is in the control source of the textbox.
It sets a quotation review date to the Monday of the following week and this is displayed in the textbox FollowUpdate and the corresponding field in the table. All dates have the medium date format.
OK, the problem is that although the correct date (Monday of the week following the quote) is stored in the field, this date value is changed each time I open the form in subsequent weeks so it keeps rolling over to the next week. Once I have the review date set when the record is entered I don't
want it changed unless it's done manually.
Please advise if you can help. Is the code/event etc correct. I would appreciate your help.
Thanks
VC
Me.[FollowUpDate].Value = Me.[QuoteDate] + (8 - Me.Text70)
The value in Text70 is calculated using the formula =DatePart("w",[QuoteDate],2) which is in the control source of the textbox.
It sets a quotation review date to the Monday of the following week and this is displayed in the textbox FollowUpdate and the corresponding field in the table. All dates have the medium date format.
OK, the problem is that although the correct date (Monday of the week following the quote) is stored in the field, this date value is changed each time I open the form in subsequent weeks so it keeps rolling over to the next week. Once I have the review date set when the record is entered I don't
want it changed unless it's done manually.
Please advise if you can help. Is the code/event etc correct. I would appreciate your help.
Thanks
VC