Results 1 to 4 of 4
  1. #1
    labgirl is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    3

    Adding data to form, not adding data to table

    I am new to access and have created an inventory database with a table, form and report so far. My intent was to add data to the form that would add itself to the inventory table. Instead, the data on the forms is only what I have added to the table. I added the button to "add new" and while it shows up in the forms, it isn't showing up in the table. What step am I missing?

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Are all of your controls (fields) in your form bound to fields in your table? If not, then the data you enter into the form is not going to go anywhere.

    Alan

  3. #3
    labgirl is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    3
    I thought I was creating the form from the table because I selected the table and then selected create form. Is there another way to bind the form to the table?

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    What you did should have bound the form to the table. You can check on the individual controls by right clicking on the control in design view and selecting properties. Under the data tab, look at the control source and make sure it is the field name in the table.

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

Similar Threads

  1. Adding data to a table
    By Jbelle7435 in forum Programming
    Replies: 17
    Last Post: 06-13-2011, 07:30 AM
  2. Replies: 3
    Last Post: 03-16-2011, 12:44 PM
  3. Collecting data off a form and adding to 2 tables
    By Phil Knapton in forum Access
    Replies: 1
    Last Post: 01-04-2011, 10:58 AM
  4. Replies: 1
    Last Post: 11-04-2010, 12:57 PM
  5. Adding a table cannot enter data
    By tak4 in forum Queries
    Replies: 0
    Last Post: 02-03-2009, 10:04 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