Adding new data

[chiefmsb]

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

[RuralGuy]

This is the method I would use: http://www.baldyweb.com/OpenArgs.htm