Reusing VBA Code To Update A Table

[Evilferret]

I have a table that I want to update (via VBA) prior to any any data being retrieved from it.

Is there a way to do this so that I don't need a separate copy of the update code for each different object that would require the table to be updated?


Is there some way to make a global VBA function and call it whenever I need to update?

[orange]

I'm sure there is, but I suggest you give us an example with some data to show us exactly what you mean.


Have you considered using a parameter query? It may be suited to your needs - maybe not.

Can you tell us more about

for each different object that would require the table to be updated

[Evilferret]

The table in question is a temp table that needs to link together a set of records each time a report is run. There are various reports that would make use of the table. The code that would need to be run is a big chunk of VBA that builds the temp table.

Looking at this now I realize that my temp table approach is inefficient. I should really be linking/relinking the tables together as the data is entered/updated rather than building a temp table on the fly.

[orange]

An example would facilitate our understanding your situation.