Results 1 to 3 of 3
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    Linked Field only showing ID not text Value

    I have tbl_Houses with Field "HouseType"


    which is linked to tbl_HouseType; "HouseTypeID", "HouseType"


    in the Report I have created to list all of the houses the report only shows the value for "HouseTypeID" not the name of the house type

    When I originally created the report it worked fine, But I have been cleaning up and changing table and field names (getting rid of spaces etc)

    I managed to get everything linked back properly on the forms I have crated but seem to be missing something on the reports to make it work

    Thanks for the help

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Sounds to me as though you need to add the table "tbl_HouseType" to the query used for the reports Record Source. Then you could add the "HouseType" field to the query which would then be available as the Control Source of a text box on the report.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Its the lookup fields biting you again (https://www.accessforums.net/showthr...527#post453527). You can use Bob's suggestion and join the lookup table into the report's recordsource and change the control source or if you already have a combo box update its rowsource to point to the tbl_HouseType: "SELECT tbl_HouseType.HouseTypeID,tbl_HouseType.HouseType FROM tbl_HouseType Order By Huse Type;". Now if you have the combo properly set up (column count =2,column widths 0";2", bound column 1) it should display the house type description.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 03-20-2017, 12:36 PM
  2. Replies: 3
    Last Post: 12-30-2015, 10:33 PM
  3. Replies: 5
    Last Post: 02-10-2015, 04:37 PM
  4. Replies: 5
    Last Post: 11-01-2013, 10:34 AM
  5. Showing Rich Text in Linked SQL Tables
    By EddieN1 in forum Access
    Replies: 0
    Last Post: 11-15-2011, 02:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums