Results 1 to 2 of 2
  1. #1
    Xterra14s is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Posts
    32

    One text box populate another text box?


    Hi, so I have one text box with a patients ID number that I need to update to another text box in a subform with the same number. I did get it to work but that was by having the text box unbound. I need it to be bound to a field that will store data into the table. Is there a way to do both? Have it auto populate based off of another text box but still be bound to the patient ID in a table? I'm assuming it involves VBA.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,524
    make both boxes bound.
    the sub form MUST connect to a table/query.
    the sub form MUST be linked via the ID box via properties:
    LINK MASTER FIELD
    LINK CHILD FIELD

    once linked the subform ID will autopopulate when you enter data.

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

Similar Threads

  1. Replies: 1
    Last Post: 05-18-2016, 09:46 AM
  2. Populate text box by clicking on a text box
    By Derrick T. Davidson in forum Programming
    Replies: 1
    Last Post: 02-03-2016, 05:56 AM
  3. populate text box
    By slimjen in forum Forms
    Replies: 4
    Last Post: 06-18-2014, 09:14 PM
  4. Replies: 3
    Last Post: 02-07-2013, 09:53 PM
  5. Replies: 2
    Last Post: 06-11-2012, 09:37 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