Results 1 to 3 of 3
  1. #1
    OverPlayed is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2018
    Posts
    6

    Update Table from Text Field on Form

    Hello,

    I have a multiple forms for different reports that I monitor daily.

    I want to create a text box for comments on each report form and use it to update the corresponding table with the comment for that specific day.



    This is basically a way to keep notes regarding issues with the reports for historical reasons.

    Does anyone know how to update a specific row in a table (by date) from a text box on a form?

    Any help would be greatly appreciated.

    Thanks!

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    If its an unbound text box, use an update query where you SET the field value = textbox value WHERE the record ID = ID for that record on the form

    OR better still use a textbox BOUND to the Notes field and it will automatically be populated
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    OverPlayed is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2018
    Posts
    6
    I am not using a primary key. The data is driven off of the date one record per day. I tried to make the text box bound to
    the field in table but I got a 'Name?' error in the text box.

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

Similar Threads

  1. Replies: 4
    Last Post: 05-09-2017, 09:55 AM
  2. UPDATE QUERY to Separate Numbers from Text in a Text Field
    By pjordan@drcog.org in forum Queries
    Replies: 2
    Last Post: 05-29-2015, 02:44 PM
  3. Replies: 0
    Last Post: 09-03-2014, 02:37 PM
  4. Replies: 5
    Last Post: 11-01-2012, 09:26 AM
  5. Replies: 2
    Last Post: 05-05-2010, 02:52 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