Open New Form with Previous Form Data

[JezLisle via AccessMonster.com]

I have an input form which the user will input all1st records. I then have a
second from which I want to input any other records on that patient number.

When the 1st form is written to the DB I also write to another table (visits)
so that it can be seen on form 2. How can I put a command button on form1 and
when clicked it will show all records for that patient, I will then click
another command button on form2 to add new records if needed.

How can I do this?

 

[bhicks11 via AccessMonster.com]

I'm a little confused by the scenario but you can just open a query from that
command button that filters on that patient number. I don't know why you
have multiple forms? You could put a subform on the first form that is a
datasheet of the patient number. You could also add new patient records on
the same form.

Bonnie
http://www.dataplus-svc.com