Type - End Type

[John]

I am trying to use the Type / End type to define a set of data. It looks
like it will fit my needs exactly,

Private Type ACTIVITY
Job as String * 4
Phase as String * 2
ActID as String * 10

etc.

End Type


When I try to compile the code I get the following error:

===================
Compile error:

Invalid inside procedure

===================

I am doing this in a Module. Do I have to move it somewhere else? In
reading the help file it indicates that a module can read it, but there is
another line that seems to indicate that they can't be defined in a module.

 

[vanderghast]

You have to place that definition in the declaration section (after the
Option Explicit and other options, and before the module defines any
procedures).

Vanderghast, Access MVP

 

[John]

That did the trick - if I had just clicked the underlined "Module Level" in
the help file it would have helped...

--
Thanks in advance!
**John**

You have to place that definition in the declaration section (after the
Option Explicit and other options, and before the module defines any
procedures).

Vanderghast, Access MVP