Run-time error...  Object doesn't support this property or method

Posted on 2005-04-21
Last Modified: 2010-05-02
I have the following hierachy of objects and collections:

Object                           Type
Trades                          Collection      
  Trade                         Object
    Details                       Collection created on initialization of object "Trade"
      Detail01                  One of several objects initialized on initialization of object "Trade"
        Exits                     Collection created on initialization of object "Detail01"
          Exit01                 One of several objects initialized and added to Exits on initialization of "TradeDetail"
            Used                 Boolean property of object "Exit"

In a seperate module I do the following:

   Dim Trades As New Collection
   Dim Entry  As New Trade
   Trades.Add Item:=Entry  

I want to set the ....Exit01.Used property.  The following doesn't work

  Trades.Entry.Details.Detail01.Exits.Exit.Used = True

Please advise  


Question by:AlphaSquared
    LVL 85

    Accepted Solution

    Try something like this:

        Trades(1).Details(1).Exits(1).Used = True

    Author Comment

    Idle Mind -- Excellent, many thanks.  A

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Introduction In a recent article ( for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
    Article by: Martin
    Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now