Results 1 to 2 of 2
  1. #1
    chiefmsb is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2006
    Location
    rockville centre, ny
    Posts
    23

    Adding new data

    I have an Info table and form. On the form I have a button to go to another form for an exam of a patient. If there is an exam then they all come up for that unique patient (I put an expression on the button for this). If there is not one I want to be able to put one in and have the ID (an autonumber) from the info table be autoentered into the InfoID field (a number, not auto) of the exam table. Where would I put this. This would also be needed where there are exams and I enter a new record I need the InfoID field updated with the ID of the info table.
    thanks , mark

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    This is the method I would use: http://www.baldyweb.com/OpenArgs.htm

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. After adding data on subform
    By Nancy in forum Forms
    Replies: 9
    Last Post: 12-22-2010, 06:19 PM
  3. Adding data to tables
    By HunterEngineeringCoop in forum Access
    Replies: 3
    Last Post: 10-19-2010, 12:01 PM
  4. Trouble adding data with forms
    By chuck130 in forum Forms
    Replies: 3
    Last Post: 09-02-2010, 09:57 AM
  5. Adding a table cannot enter data
    By tak4 in forum Queries
    Replies: 0
    Last Post: 02-03-2009, 10:04 AM

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