I have a table of manufacturers. I have another table of products produced by those manufacturers.
I would like to have a continuous form displaying manufacturers with a continuous subform displaying the products of the selected manufacturer, but, so far as I can determine from reading on the web, Access does not support both the main and subform being continuous.
The https://support.microsoft.com/en-us/...a-215f5ec8bb39 web site describes how to link two forms using XML. It seems to work but I do not know XML and would rather not integrate something into my work which I do not understand and which would be difficult for me to maintain.
Did not find any help on the internet in general or this site specifically. Although when I search accessforums.net for “linked forms” there are thousands of hits returned. I looked through the first several hundred and gave it up. Is there a better way to search? Seems likely this has been discussed before.
So . . . how does one link two continuous forms with VBA? Not a main form/subform relationship but two standalone forms which are linked, in this case, by the mfrID field?
Thanks.
Steve