Results 1 to 4 of 4
  1. #1
    NJK is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jul 2015
    Posts
    4

    Different table control source


    Hi, I have looking for an answer for this but cannot find.

    I have a textbox on a form and I want the control source of the text box to be a field which is in a different table. So the form has a record source of a table called tblstatus but I want the control source for the textbox to be a field on another table called tblContractor.

    How do I do this?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    A form can do data entry/edit for only one table. Other tables can be included in the form RecordSource for display of related info but cannot enter/edit data of the other table.

    If you want to save a value from tblContractor, such as the ContractorID, use a combobox bound to field in tblStatus and the combobox RowSource will be a query to pull a list of contractors.
    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. #3
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    but I want the control source for the textbox to be a field on another table called tblContractor.
    depending on what this textbox is required to do, look at using the dlookup function or as June7 suggests, use a combobox

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    tblstatus but I want the control source for the textbox to be a field on another table called tblContractor.
    Is there a relationship between tblstatus and tblContractor? If so, then you could use a Main form/sub form arrangement.

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

Similar Threads

  1. Replies: 3
    Last Post: 05-15-2014, 01:13 PM
  2. Replies: 7
    Last Post: 08-13-2013, 03:54 PM
  3. Replies: 1
    Last Post: 04-23-2013, 03:35 PM
  4. Control Source on Form Reading Value in Table
    By hammer187 in forum Forms
    Replies: 1
    Last Post: 10-23-2012, 02:43 PM
  5. Should forms use a table or query as their control source?
    By cheyanne in forum Database Design
    Replies: 2
    Last Post: 05-30-2012, 04:00 AM

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