I'm currently working on a database where the user will regularly be entering a bunch of data for each a given day. This work is often done in advance, so I would like to create a query (which I can then use a button to run on my form) that will change the default value of the date field so that it does not regularly need to entered.
I understand that I can use Date()+1 to automatically have it be tomorrow's date at all times, but as data will often be entered for other days besides just tomorrow I would like to make it a query so that the user can easily change the default value of the field.
Can this be done?