"Andy" wrote:

Already using that code.

Actually you're not based on your initial posting. Gina's code has
the error handling in it. Which, if inserted in the may give us a
better error message.

It doesn't generate an Error Message. Just gets a RunTime Crash.

By runtime crash you mean
"Execution of this application has stopped due to a run-time error."
"The application can't continue and will be shut down."

If so inserting the error handling as per Gina's suggestion will
likely result in a more meaningful message.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/