OK - that makes more sense.

I think I would have tried one of the following:
- give those who haven't got a licensed version of Access the Run-time
version of Access instead and use the Access form.
- build the form in Excel and write a little code to upload the
information to Access via an INSERT query or a Recordset

But there's always a variety of ways to achieve ones goals

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup