How to link two continuous forms with VBA?

[steve7800]

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

[Micron]

A main form with 2 continuous subs and nothing else? You would have to filter the product form with manufacturer form Current Event, using a field which needs to be common between them. Not sure if that makes sense to you.

[orange]

Can you mock up a sample using terms like PorkyPig Mfg, DffyDuck Mfg... with products like Big wrench, little wrench, hammer, bolts.... and show us what your expected output would/should look like?

What is the problem with form/subform for your application?

[June7]

This what you want? https://www.fmsinc.com/MicrosoftAcce...edSubforms.asp

[ssanfu]

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.

I do this all of the time. If you create a main form with a sub form and set the linking Master/Child fields and both forms are set to "Continuous Forms", Access will complain and set one form (the main form I think) to "Single Form".
Just go back and set both forms to "Continuous Forms". Done!

Change the current record in the main form and the sub form changes to the show the linked records.





If you have two stand alone forms, you can link them like this

[steve7800]

Thanks for the several suggestions.

Three of you suggested looking at a form with two subforms, each subform continuous and linked via an intermediate text box. That works well and is straight forward to implement.

ssnafu also provided an example database with two standalone forms linked through a query. This is what I have tried to do from time to time but never got it to work. So thanks for that ssnafu

Also got some off-forum help from another accessforums member.

So now I have two ways to link a pair of continuous forms. When I posted the question I had none. Big thanks to all of you!

Steve

[orange]

Good stuff! We're all happy to help.