Results 1 to 2 of 2
  1. #1
    dalton is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    11

    Saving info to the database

    I have a main form with a list box and when I double click on a person's name in the list box it opens a second form with that persons expanded information. I'd basically like to use that same form to add a new person to the database. I figure that if I have a save button at the bottom of this form, then I could put a button on the main form called "add" and have it open to this form with the text boxes blank. It would work for the expanded information, because it would really be like a save edits button. It would save a new contact from the blank form, but would just save any updates on an already existing contact.

    Is this feasible or would I need a seperate add contact form? If it is, how do I go about doing this? Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    You should be able to use the same form. Look at the arguments for OpenForm in VBA help. One of them determines the mode the form opens in; you want the one for data entry.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. record saving twice in table
    By ds_8805 in forum Forms
    Replies: 15
    Last Post: 04-14-2010, 07:16 PM
  2. Export query without saving
    By prag in forum Queries
    Replies: 1
    Last Post: 11-18-2009, 06:22 PM
  3. Saving Print Settings
    By spinny in forum Queries
    Replies: 1
    Last Post: 06-23-2009, 12:58 PM
  4. SQL- retrieving info
    By jmarti57 in forum Programming
    Replies: 0
    Last Post: 12-10-2008, 03:05 PM
  5. Combo Box isnt saving
    By calisen in forum Access
    Replies: 0
    Last Post: 09-11-2008, 03:34 PM

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
  •  
Other Forums: Microsoft Office Forums