Robert,

I am an inexperienced user like yourself, however i have the same problem as
you i found that DAO works better with this than MS Query and ODBC (look it
up on the MS knowledge base), it took me a little while to follow it, but it
works so much better, you can even pass parameters back to Access etc. I
haven't figured out the SQL it needs to query as well as MS Query, so
personally i just make the query how i want it in Access and then pull that
through using DAO.

HTH.
Emma





"Robert" wrote:

I need to aquire the name of the range that was used in Data Validation
programatically at runtime.

Many Thanks
--
Robert Hill