It disappears if something is uncompilable. Try Compile on the Debug menu.
If that doesn't solve the problem, try restarting.
If it still doesn't show, it may indicate a corruption. Decompile a copy of
the database by entering something like this at the command prompt while
Access is not running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
You can help by removing any references you don't need, since there are then
fewer libraries that it has to interpret. If you are not sure what libraries
you need, see:
http://members.iinet.net.au/~allenbrowne/ser-38.html
There will be some contexts where Access is not able to provide the
enumerations because it is not sure of the context. For example, if you
type:
With Me.RecordsetClone
Access don't know what kind of recordset that is. If you type:
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
With rs
then the context is clear for that reference.
