I have a Subform that I want to open to the last record but I keep getting a warning when the macro runs to open the main form holds the subform. The warning tells me (basically) that the subform is not open.
I also want to run a calculation on the circled field in the subform that uses the circled field in the main form but I can't make it work.
Both the form and the subform are designed from tables (not queries) however the tables have a common field relationship.
Detail: a person's height does not change but their weight can. The subform's table holds data records from subsequent measurements of weight and blood pressure, etc. by date of visit.
The height field is in the main form and the subform holds a weight field. I am trying to run a macro that calculates BMI using the person's height and a variable weight.
Any help would be greatly appreciated.
Mark