Searching and Reporting

[sstasiak]

I'm trying to set something up to track patients weight history. I have primary key in the main table(MEDRECNO) set to have many (WeightID)'s in the 'Weight' table.

In the main form, I have a 'Weight' subform. I want to add a button in the subform that when clicked, will search the 'Weight' table and pop up a brief report of the patients weight history starting with the most recent weight taken. The report should show the patients name(from main table), MEDRECNO(also in main table), and all associated weight entries(from 'Weight' table)

Any help is appreciated.

 

[Remou]

Why not just show the weights as a subform on the main form? Alternatively, you can open a form using the Where argument of OpenForm.