Results 1 to 2 of 2
  1. #1
    shaileen.shah is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    1

    Linking Database tables and forms


    Hello,

    I am new to access.
    I am developing something like this:

    There is a table with different attributes, and there is a form which has different types of controls like text-box, combo box, labels, etc.

    What I need to do is when I enter the information in the form, it should be stored in database.
    for eg.,

    If I enter firstname in the form, it should be stored in the table.

    Can you please let me know how do i do this?

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    If you created your table first, then the simplest way, is to use the Access Form Wizard to create your form based upon the table. Now your table is bound to the form. Everytime you enter data into the form, it will automatically appear in the table. If you wish to design your own form and not have the wizard do it, then look at this tutorial.

    http://cisnet.baruch.cuny.edu/holowc...accessall.html

    Alan

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

Similar Threads

  1. Linking Forms
    By glasgowlad1999 in forum Forms
    Replies: 1
    Last Post: 02-02-2011, 09:35 AM
  2. Linking two forms together
    By Lxmanager in forum Access
    Replies: 8
    Last Post: 09-27-2010, 05:10 PM
  3. Linking large number of forms and tables
    By jlcaviglia-harris in forum Forms
    Replies: 2
    Last Post: 04-17-2009, 09:19 AM
  4. Resource for using linking tables with forms?
    By narayanis in forum Forms
    Replies: 5
    Last Post: 05-18-2008, 04:11 PM
  5. Linking tables and forms
    By vgatell in forum Access
    Replies: 0
    Last Post: 02-10-2007, 01:37 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