I have a number of queries that are created dynamically based on client/model. i can create lists of those no problem. What I am unsure of is how to create the subforms and get them onto a master form.
so for example:
Access has done its work and created two queries:
so I want to align the two (in this case) subforms next to each other on the master form.
That bit I am struggling to implement is if i had two sets of models (or more):
QryCap3Series for info these show all bmw 3 series models for these two clients
QryCapCClass for info these show all mercedes CClass models for these two clients
I would need a combo on the master form that would then allow me to choose which model set.
not sure how to inplement that.
I am in vba