Hello all,
I have been slowly building a decent size database over a few years and am now thinking of rebuilding it with better coding I have learned over the years. With regards to modules, I have been moving everything over to public functions. The advice I am after is about the most efficient way to have this designed.
As an example I have an cmdAdd function. Now, here is where I want feedback/input. The cmdAdd function has different options depending on which form you are on. At the moment I have the code checking with form it is on and then performing that version of the cmdAdd. Let's say I want to add a new quote, it looks for frmCustomerOverview and then runs the cmdAdd in the add quote part. If it was on a different form it would perform a different function.
Is this an efficient way to code things, or would I be better having a cmdAddQuote as a stand alone function, and so on for all the other functions. At the moment the cmdAdd has 10 different forms with different add functions on each one.
My thoughts in doing it this way was that all the add functions were in one code and easy to find and manage, I was just not sure on the performance issues doing it this way.
Regards,
~Matt