Design advice needed

Hi Folks -

I have an MS Access Database with quite a few Functions. Each function serves a different purposes but there are functions where I am re-using most of the same values in arrays. Therefore, rather than maintain each Function, I want to maintain 1 section where I identify the array value(s) and then indicate the Function it should be made available in, if that makes sense?

For this example, I have (3) functions that all use 90% of the same array values. My hope is to central maintain that list by identifying the full set of values and then indicating what function each value belongs to. And then when the Function is executed, it will read the array value AS WELL potentially another value that checks if this value should be used in "this" array. If so, continue, if not, skip.

I have attached an excel workbook with the Master List of value and where each value should be used as an example.

Below is a Function I currently use so I'd need to update based on the suggestions here.

Please Login or Register  to view this content.

Any suggestions are greatly appreciated, thank you all!

You've posted to the Excel VBA section - did you mean to post in the Access area? I can move this for you, if so.

Moved to the Access VBA section.