You could call it something like MasterID. To solve your issue with dynamically chaning the sub-forms, what you might consider is using a universal ID name in your sub-form 1 record source by setting an alias in the underlying query. Me.Control.ControlSource = "=.!"Įspecially thank you for your thinking so far. The only solution I see currently is, the condition in the Control field also change dynamically depending on the source object of subfrm-1, something like: Possibly you have an appropriate solution from your experience for me? I have my original dbtest adjusted by adding "-01" and put back into dropbox available so you Would you herein once again like to think with me? IIF if I can not use, I'm afraid I have another problem.
Only now you bump into other things, such as the problem: how do I then get a "dynamic" control field? In this way, the number of open links can be significantly reduced.
I me something into this matter and thought to have a possible solution by working more with dynamic forms, which subforms are loaded only when there is real need. Large database application designed where what I run up against the limits of open database links (Error #: 3048). Is this explained? Can I prevent this and still use a dependent condition in this field? You have to see this against the background that I have quite a I suspect it's because I so an IIF function field use "Control". It is strange that it only goes wrong when the subform is based on a group/summing-qyery, as currently in sf2. However there was about normal selection queries. I've used this before with success, without problems. Load in the main form the subforms dynamic, depending on the user's choice, I thought I would do well to make dependent the link field ("Control") or the "Source Object" exists or not. It's not because I'm the "Control" use, but because the condition in this field causes the error. I'm already behind whereby the problem is caused. Hello Tom, Thanks for your effort! This has helped me in the right direction. The total counts, thus permanently removing the census is no solution. Only when I remove theĬounting fields in the formfooter of subform 2 the message "Calculating" In the status bar constantly is schowing the message " Calculate". When I open the main form, all information is displayed correctly. I made a count in the formfooter of subform 2, which I take over to the main form. Is based on a cumulative query with group totals. SubformĢ is with a control field associated with the first sub form, so that subformĢ shows only the records with the same X - ID of the first subform. Nu toont subform 1 de records uit tabel 1. Of each record in Table 1 ( compare with order details ). The tables contains the following values: Table 1 have I have a main form containing two sub-forms.
0 kommentar(er)
