Open New Form with Previous Form Data "JezLisle via AccessMonster.com" <u43150[ at ]uwe> 11/13/2008 10:38:47 AM 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1

Re: Open New Form with Previous Form Data "bhicks11 via AccessMonster.com" <u44327[ at ]uwe> 11/13/2008 11:55:06 AM 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 JezLisle wrote: [Quoted Text] >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? -- Message posted via http://www.accessmonster.com