I thought I know how to do this. I know the concept but it didn't work.
I created a macro, name is autoexec (so when access is open it auto run) then assign this macro to run a code or function that I build.
I tried it but it didn't work, not sure why.
I get the error message
The name is correct and is there and is a function in a module.Microsoft Access cannot find the name fxup you entered in the expression.
You may have specified a control that wasn't on the current object without specifying the correct form or report context.
Please advise !