Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Angry Unanswered: Cant find control source

    I have an access db I downloaded for free for helping track issues. Its pretty simple but I've tried adding a field or two for things like Asset ID numbers and a closed date for the issue. The problem is after I create a table of Asset ID's for my Issues form I try and create a combo or list box on the form but I never get the option to select my table of Asset ID's as the control source. The only control sources listed are for tables already there. How do I get Access to see my new table and list it as a control source? Thanks so much for all your help. This problem has been driving me crazy the past few days.

    mrem

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580
    You have created Fields of AssetID and Closed Date - In which table?

    'after I create a table of Asset ID's' - Using the same table?

    Can you do a screengrab of your tables and their design please and post?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    What version of Access?

    I've heard a similar problem where new tables don't show up in wizards. I can't remember what the solution is as I don't ever use wizards but I believe that problem was only for Access 2007.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •