I think the word "report" here does not refer to an Access report:
there is button that opens health reports only for that patient (it filters the
form)
I want that button to open a new record of the health reports
form
Anyway, there are decent answers at the other thread - I guess as long as it's understood that the 2nd form is based on a query or table that uses the id from the current record of the first form. A problem I think I see with having a default value setting on form2 is that errors will probably be raised whenever that form is opened and form1 is not open. Also, form2 would likely have to be modal, otherwise the current record on form1 could be changed by the user while form2 is still open.
Last edited by Micron; 12-26-2023 at 09:36 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.