I have a form with a subform on it which is linked to a different table than the parent form. I want to display info from the subform on the parent form. Is it more efficient to use a reference to the subform on the parent form textbox (=[subform]![control]) or use a =dlookup() based on the currently selected record id on the subform?
There are about 12 text boxes that need info from this subform/other table.
Can I use all dlookups instead of the subform or is it better to use a subform