[RESOLVED] Coerced late-bound type error

[L0ngman]

I have two modules in my access vba project which are part of the problem.
One module contains two types:

Option Compare Database
Option Explicit
 
Public Type CacheTblRow
        RowItem() As String
End Type
 
Public Type CacheTbl
        Row() As CacheTblRow
        Success As Boolean
        FieldNamesOrdered() As String
End Type

I have a procedure in the other module that uses these types to declare variables, but when the code gets to these lines I get error:"Only user-defined types defined in public object modules can be coerced to or from a variant or passed to late-bound functions". Below is my declaration in the 2nd module, in a procedure:

Dim Duplicate_Table As CacheTbl

I really am not sure how to fix this. I have used a different type in my code ealier and that worked, but it was not a nested type.

Any advice greatfully received.

Rich

[MartinLiss]

I moved your thread to here where questions about VBA are asked.

[randem]

VBA questions are asked in the Application Deployment Forum???

[L0ngman]

So am I supposed to move my post myself? , to "Office development" ?.

Admin seemed to suggest it had been done by them, although i don't see it being moved, it's in the same section - "Classic vb".

[randem]

No, you can't move it. That's what puzzled me that it seemed to be moved here.