AutoUpdate Date.

[Jeremy Sng]

I got an issue here.

I have a table with date keyed on 8/2/17 but the next day open access it will be 9/2/17. Is access able to auto update date that i keyed and change itself to 9/2/17.

Thanks

[andy49]

Only if the default setting is date() or there's an event somewhere that triggers the change

[Jeremy Sng]

So at which event the date will auto-change change?

[andy49]

Does the field appear on a form anywhere? If so, can that field be changed? For the tbl to change, either the default value is set to date() or a bound field on a form has been changed.

I'm happy to look at the database if you can zip it.

[AccessPower]

You can do this on the on_load event of the form.

[Jeremy Sng]

Can you tell me more about the on_load event of the form?

[Jeremy Sng]

I will appear in a new line in the tbl but i want the date to update in the keyed row. Eg. 8/2/17 and update to 9/2/17 which i don't need to update myself in the tbl.

Hope you understand my explaination.

Thanks

[andy49]

is it possible to zip your database for us to look at. Easier to find.

even if you make a copy and give us made up data

[Jeremy Sng]

The outcome has out. Even i put =Date() it wont update the tbl keyed rows. i think is it possible to do it in the queries or form?