Page 5 of 5 FirstFirst 12345
Results 61 to 67 of 67
  1. #61
    DBID10T is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    46
    tblCustomerType has a ShortText field called CustomerType Which I am trying to reference for display when a certain CustomerID_PK is displayed in TxtBoxCustomerID on my form



    it is on my Customer Information Form I want it to update with the Word not the Code for customer type

  2. #62
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Then you need the CustomerTypeID to find its associated CustomerType with DLookup.

    But DLookup should not be necessary. A combobox on your form for selecting CustomerType should display CustomerType. The combobox RowSource would be: SELECT CustomerTypeID_PK, CustomerType FROM tblCustomerType;
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #63
    DBID10T is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    46
    tblCustomerType is used to ?index? my tblCustomer with a CustomerTypeID_FK field. Basically A 1 is a Residential Client and 2 is a Commercial Client. I want to update a Text Box with Residential or Commercial depending on which Customer record is being looked at

    I agree it would be better for others if some of these questions and answers are not buried in a thread 185 replies and queries long.

  4. #64
    DBID10T is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    46
    Can't you change the value on the combo box? I don't want it changed unless your in actual new customer form. this is a Project Form I just want to display the customer type for reference.

  5. #65
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Alternatives to combobox:

    1. include table in form RecordSource

    2. in textbox: =DLookup("CustomerType", "tblCustomerType", "CustomerTypeID_PK=" & [CustomerTypeID_FK])
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #66
    DBID10T is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    46
    My Thanks to:

    June7
    Ajax
    Orange and
    Ssnafu.

    You all have been instrumental in my changing the Turd of a Database I stumbled into here a few days ago with into a halfway decent DB for a Total DB Idiot like myself.

    You all have truly taught this man to fish in the data ocean, and you have my thanks.

    Until the next Question! Mods lock this puppy I think we are done here.

    DBID10T out.

  7. #67
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Any poster in a thread is able to mark as 'Solved'. Use Thread Tools dropdown at top.

    Good luck!
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Page 5 of 5 FirstFirst 12345
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help please, total newbie in the deep dish
    By Peanutdust in forum Reports
    Replies: 2
    Last Post: 09-14-2017, 05:35 AM
  2. Newbie getting stuck with summing queries
    By snorky in forum Access
    Replies: 2
    Last Post: 01-19-2012, 03:42 PM
  3. stuck on expression for total query records
    By pacer31 in forum Queries
    Replies: 3
    Last Post: 07-04-2011, 11:30 AM
  4. Newbie Here & Stuck
    By FOZILD in forum Access
    Replies: 5
    Last Post: 09-24-2009, 08:26 AM
  5. :?: newbie...grand total?
    By PnerraD in forum Access
    Replies: 1
    Last Post: 08-24-2006, 06:28 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