There is a TON of free stuff on the net - articles, videos; some publishers do a whole series of videos, all free. If your preference is a book, you could probably find a pdf copy of old books on line (e.g. Access 2000 Bible), or try Amazon or eBay for used books. While some of them might seem dated, they would suffice to start with since not much has changed wrt VBA over the years. The biggest difference between new and old would be the properties, methods and events for some objects that were not around way back when, but the principles of how to work with them are the same, regardless of how old these objects are. What you need is the fundamentals, not necessarily the latest and greatest. Unless you have a mind like a sponge and will remember everything you set your eyes upon, don't expect to master vba any time soon. My main caution is that some old books will treat certain aspects of Access as if they are great things but you should avoid them. One would be replication. Regardless of how great it was or wasn't, it is no longer. Don't waste time on it. Another would be the impending demise of DAO in favour of ADO. M$ reversed the course so it is no longer true. Suggest also that you research multi value fields, table level lookup fields and attachment fields before believing whatever a book tells you about them. After all, the authors need to stay on the good side of M$ (that's my opinion) so it is likely that they would never use these abominations but will not admit it.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.