Results 1 to 2 of 2
  1. #1
    earlyr is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2013
    Posts
    1

    Post Link Form to Table

    Hello I'm new to this forum and access. I am trying to link a text box in my form to a particular column and row in my linked table.

    I have several rows:
    Jan Feb
    Account 1 (Text Box1) (Text Box2)


    Account 2 (Text Box3) (Text Box4)

    Currently, if I populate TextBox1 it also populates Text Box3 with the same number. How do I change this so you input each Text Box separately?
    I have the Text Boxs for Jan linked to "January" column in my table. How do I make it so Text Box1 goes to row 1 and Text Box3 goes to row 2 in the "January" column?

    Thanks in advance for the help!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Textbox1 and textbox3 are the same control and textbox2 and textbox4 are the same control. Look at the form in design view and you will see this.

    You say textboxes are linked to fields but they are acting like they are UNBOUND. Control will show the same value for each record unless it is bound to field or has an expression. What is in the ControlSource property for each textbox?
    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.

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

Similar Threads

  1. Replies: 25
    Last Post: 08-01-2012, 05:22 PM
  2. Replies: 2
    Last Post: 12-20-2011, 07:33 AM
  3. Replies: 2
    Last Post: 08-01-2011, 11:35 PM
  4. Form loosing link to table
    By kcm4491 in forum Forms
    Replies: 9
    Last Post: 03-23-2011, 07:27 AM
  5. link excel form to access table
    By data123 in forum Import/Export Data
    Replies: 6
    Last Post: 06-23-2006, 10:17 AM

Tags for this Thread

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