Warning Message After Changing Date

[Mahendra1000]

Hello All,

I have a database with StartingDate, EndingDate, MonthName, QuarterNumber and YearNumber.As (MonthName, QuarterNumber and YearNumber are based on the EndingDate)

If user changes the EndingDate then there needs to be an alert message to modify the MonthName, QuarterNumber and YearNumber.

I used the afterupdate/afterchange events but the access is displaying the alert message if user enters the endingdate for a fresh record.



I just don't want to show the alert message for the fresh records while entering. It needs to show only when the endingdate is changed after entering at first.

[Homegrownandy]

Can you show us the code you have for the message? How about a separate form for editing?

So, you would have a list form... then next to each record is a button that opens a sub form to make amendments. The message code could be applied to just this form.

You could have the main form locked for editing but additions enabled... There's many ways to do it.

[Mahendra1000]

I don't have any code for that. I just created a macro in afterchange property box to display an alert message

[Homegrownandy]

I'm sure what you're asking for can be done but I'm not too sharp on the macros/vba.



The first list is locked here. The form that's opened is for adding or editing records. I also have the same form to open blank when add new is clicked.

It doesn't answer your question but it might give you a different way to achieve it. (you would need a separate form for adding new if your macro applies to all changes)

Andy,

[nick404]

Yes it will display the alert message for any time the control that you are entering the end date in updates. So going from Null -> having data counts as an update and the message will trigger.

I would go with what Andy suggested and create a button to open up a smaller 'pop-up' style form for editing data.
If you end up having an alert message to change the other fields, might as well just utilize a small form to edit all at once and instead have the alert message kick if they try and leave the page without editing the other fields.