In order to learn more about macros I’m trying to execute an SQL statement from a button.
I stripped down a database to the absolute minimum to explain my problem.
In the form frm_prefs I created a button to update the field InvoiceYear. The last line in the macro seems to be wrong and I’ve been looking around for a solution without luck.
Maybe someone here can point me in the right direction?