Results 1 to 3 of 3
  1. #1
    MJCRN is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    4

    Updating Table with new Form Entry

    Hello,
    As I am new to MS Access 2010, I feel pretty certain this is a simple question which I hope has a simple answer. I have created a form that is bound to a particular table. After all is complete and we have used the form for a while, we realized we would like to add a question on the form that was not on the original table. I have added the question to the original table AND the form but how can I now have the answer or check-box (in this case) sent back to the table without re-creating the whole form?
    Please help.
    Thanks.

  2. #2
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,424
    I have added the question to the original table AND the form but how can I now have the answer or check-box (in this case) sent back to the table without re-creating the whole form?
    Are you sure you don't mean the question is a label and the answer (checkbox yes/no) is what you added to the table? If not, you have stated where you put the question, but not the answer. If my assumption is correct, go to the form in design view, make sure the property sheet is visible, select the checkbox you added and on the property sheet, assign the control source to the table field you added.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I have added the question to the original table
    Sounds like you are committing "spreadsheet".
    I am really curious what your table structures look like..........

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

Similar Threads

  1. Updating a primary key based on form entry
    By Confused in access in forum Forms
    Replies: 7
    Last Post: 08-24-2015, 04:21 PM
  2. Replies: 3
    Last Post: 06-04-2015, 09:48 AM
  3. Replies: 12
    Last Post: 11-11-2014, 02:10 PM
  4. Updating main table from temp table AND form value
    By shabbaranks in forum Programming
    Replies: 8
    Last Post: 05-01-2013, 07:18 AM
  5. Replies: 2
    Last Post: 08-02-2011, 07:25 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