Hello All,
I am new to VBA and have been asked at work to rewrite an Inventory database.
I have designed the tables and then used the form wizard to create the forms. I have then edited the forms so that they include navigation buttons written in VBA.
however, all the forms now have the same code for the buttons. Is there a way/place that I can write the procedure once and then refer to this procedure on each form instead of having the same sub routine many times for each form?
I appreciate this may be an obvious question but being new to VBA i'm unsure about adding VBA code to each individual form or if I should use a module etc.
Any help very much appreciated as I start to learn VBA. Thanks in advance