Results 1 to 2 of 2

Editable textbox to update subform

  1. #1
    fhickler is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2018

    Editable textbox to update subform

    I'm still a bit of a novice at Access and VBA, so this may seem trivial, but this is what I'm trying to achieve:

    Table - call it Table1 - which includes a field called Field1
    A form that contains the following:
    - A subform of Table1 - call it subTable1 - in datasheet format
    - A textbox - call it Textbox1 - that displays value of Field1 of record selected in subTable1

    Easy enough.

    BUT I want Textbox1 to be editable and, when edited, to update also in Table1. What would be an uncomplicated way to achieve this?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Nevada, USA
    How would a textbox in the main form know which record to update? Without specifying, it would update the first or currently selected record. An update query could work, or code that updated the active record in the subform.
    Paul (wino moderator)
    MS Access MVP

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

Similar Threads

  1. Replies: 5
    Last Post: 04-30-2015, 01:50 AM
  2. Replies: 5
    Last Post: 07-15-2014, 09:56 PM
  3. Unbound Form and Editable Subform
    By tndinnc in forum Forms
    Replies: 6
    Last Post: 04-19-2013, 05:42 PM
  4. Updatable & editable subform?
    By jfn15 in forum Forms
    Replies: 2
    Last Post: 06-21-2011, 10:35 AM
  5. Replies: 3
    Last Post: 02-10-2010, 07:29 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
Tech Forums: Microsoft Office Forums