I have 2 forms: a main form and notes and comment form. One opens the other.

My database is setup where some of the forms have the same ID# (Unique Key). The reason, ex. Tom Smith was discharged from care and then readmitted with a different Admission Date but the ID# will stay the same.

My question: I want to be able to open up the notes and comment form based on the Admission Date. It currently defaults to the orginal date. (Setup for Notes and Comments Form; ID#, Admission Date, Last Name, First Name)

Any help in advance will be greatly appreciated.

Assuming you have two separate tables one with patient details name etc patient ID, second one with patient ID admission dates illness etclinked as one to many then just create a main form and subform linked by patient ID if you sort the date field Desc the latest admission date will show first the notes field could go in either table depending on how you wished to look at them ie. as one continuous memo or in the second table if you want separate notes for each visit