Results 1 to 7 of 7
  1. #1
    kmw is offline Novice
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    27

    Adding a single new record using multiple forms

    I want to create a database that will add new records individually but there are so many attributes that I needed to use 5 different forms rather than one very large form. I am having trouble having the 2nd, 3rd, 4th and 5th forms add the new values to the existing row.



    Right now I have an EMPLOYEE table where a new employee is added. The next forms all add information but I need them to update the existing row using the unique ID number that an AutoNumber.

    I want the second form to access the record that was created with my first form. Can I have an Update Query that automatically edits the most recent record added?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,320
    Well, you can use this technique to open the second form to the same record:

    BaldyWeb wherecondition

    But personally I'd probably use a tab control on a single form to organize the fields into logical groups. That way you only have one form to maintain.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    kmw is offline Novice
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    27
    I have about 70 attributes in the table and I was having trouble keeping everything straight with my append query. With 70 attributes you would still use a single form and one query?

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,320
    Don't see why not, though 70 makes me wonder about normalization issues. You're using unbound forms?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    kmw is offline Novice
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    27
    Mostly combo boxes

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,320
    The thread is marked solved; does that mean you've got it sorted out?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    kmw is offline Novice
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    27
    Yeah I went back to using one form but I was extra careful with the expression builder

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

Similar Threads

  1. Replies: 5
    Last Post: 12-04-2011, 10:52 PM
  2. Replies: 5
    Last Post: 08-29-2011, 05:17 PM
  3. Replies: 0
    Last Post: 03-30-2011, 09:50 AM
  4. Replies: 8
    Last Post: 01-21-2011, 10:28 AM
  5. Adding a single record
    By kfoyil in forum Forms
    Replies: 2
    Last Post: 11-22-2006, 09:12 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 - Senior Forums