Ok, I am wondering if anyone can help me here.

I am working with a table containing a list of ID numbers.  I have a
function, NextFreeIDNumber(), which will return the next free ID number
for use in this table.  In other words, if IDs 1-8000 are all taken in the
table, then NextFreeIDNumber() should return 8001.

Well, to run this function is pretty slow.  I thought perhaps I could have
a hidden form periodically run this function so that other forms could
instantly retrieve the next free ID number on demand.  However, I didn't
realize that when the function is run, the whole application halts until
it's done.

Suggestions?

--
joel thornton
mirage marketing

Post the code...

Joel

A real cheat. Have a separate table with just 1 record - the last number
used.  When you need it only 1 record to find which you then update.

:-)

Terry