Hi Cathy,
That all depents on the type of data your are pulling from DBA ( And the Quantity).
I have over 15 apps that are use everyday and they "get" the data on a diferent way.
Here is a few examples:
PO Search: this app is divide into two the client and the Server. The server runs every nigth and update its tables. The client does not update anything.
SO Search: Again devide into client and server. The firts emp who opens its app will update the server. The rest will not have any need to update.
Job Costing: Client only. The app change the pass through query every time it request data from DBA.
Inv Reorder Level. Clien only. It updates its data every time the client is open.
As you can see that all depents on your app.
Heres is a few techniques that you can use:
Use an Autoexec Macro: It updates its data every time the client is open.
Modify your Query by code: var_sql = "SELECT * FROM WORKORD WHERE MTWO_WIP_WOPRE = 20515" then CurrentDb.QueryDefs("DBA_PASSQUERY").sql = var_sql
I will be glad to help you if you give me more information
Kelloggs