Is it possible to call a function from within a function but not wait for the called function to complete before completing the orriginal function? In other words Function1 calls Function2, but Function1 doesn't wait for Function2 to complete so Function1 may finish before Function2.

That’s not a bad description of multitasking; unfortunately, to pull something like that off, you need a language that allows you to spawn, manage, and kill your own threads. VBA doesn’t directly support multi-threading, but there are some VB6 dll’s out there (like half-Time Technologies Thread Factory) that enable you to create multi-threaded VBA applications using apartment threaded COM components. The .NET languages super-simplify the process with the framework’s new Thread class that has Start, Sleep, Suspend, Abort, Resume, etc. methods, and C/C++ programmer’s have always been able to call the Win32 API CreateThread function. Can’t be done directly in Access VBA, though. :(

HTH,

Bob

Although disappointing, thanks for the info!

Eric