Microsoft Access / VBA is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).
You can ask the experts in the dedicated forums over here:
Microsoft Access
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access
Visual Basic for Applications
https://social.msdn.microsoft.com/Forums/en-US/home?forum=isvvba
(Please don't forget to accept helpful replies as answer)
Best regards,
Leon