If I put a " dim wrkjet as workspace " into an event on a
form, it flags workspace as an undefined user type. If I
put the same line into a form of the Northwind example, in
the same event, it works fine.

Both of these are done on the same compujter.

This tells me that there is some setting that controls the
scope of these keywords. I also not that the autocomplete
fills in workspace in the Northwind form, but does not
have this as a posible item in my form.

Thanks

Hi Courtenay ,

My name is Joseph Moore.  Thank you for using the Microsoft Access
Newsgroups.

You will need to make a reference to Microsoft DAO 3.7 Object Library in
your Reference list.  You can access the list by opening the Visual Basic
Editor, selecting Tools in the menubar and choosing References.  You will
need to make sure that you specifically reference DAO in your code or that
you give DAO priority over ADO.

More information is available in the following knowledge base article:

225962.KB.EN-US ACC2000: By Default, New Access Databases Do Not Include
Reference to
http://support.microsoft.com/default.aspx?scid=KB;EN-US;225962

I hope this helps!  If you have additional questions on this topic, please
respond back to this posting.

Regards,

Joseph Moore
Microsoft Access Engineer

This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.