WorkingVBA
Registered User.
- Local time
- Today, 03:42
- Joined
- Jul 3, 2013
- Messages
- 33
Hi,
This is more of a best approach question. I have been wrestling with this problem for a few days and would like to see if anyone can give me some ideas for a best approach before I spent too much time in development.
I have both a form and a report with continuous sub-forms. Presently, both the form and report are set up in single view with the continuous sub-forms in place. Everything works.
We are looking to make the form more flexible, thus the number of sub-forms and their content may vary at the time that the form or report are called. This would be a relatively simple thing to do if you could build a continuous form/report that had the ability to contain sub-continuous forms/reports. As I understand it this is not possible (MS Access restriction for whatever reason)
I know that it is possible to create a form/report while calling it using VBA. Thus in theory one might build a single form, adding the needed continuous sub-forms/reports to the form/report at the time it is called.
So here are the questions:
1. Am I on the right track here, or is there some other way to do this, I might not have considered? And,
2. If the latter approach (building the form with vba at the time it is called) is the best way, does anyone know of a good white paper or post that would show me how to do this (I am afraid that I have never done anything like this before)
NOTE: The above post describes creating embedded continuous forms and reports. You can do what I described in a report, but I need to replicate this flexibility for a form as well.
Thanks for your guidance, the help is much appreciated.
This is more of a best approach question. I have been wrestling with this problem for a few days and would like to see if anyone can give me some ideas for a best approach before I spent too much time in development.
I have both a form and a report with continuous sub-forms. Presently, both the form and report are set up in single view with the continuous sub-forms in place. Everything works.
We are looking to make the form more flexible, thus the number of sub-forms and their content may vary at the time that the form or report are called. This would be a relatively simple thing to do if you could build a continuous form/report that had the ability to contain sub-continuous forms/reports. As I understand it this is not possible (MS Access restriction for whatever reason)
I know that it is possible to create a form/report while calling it using VBA. Thus in theory one might build a single form, adding the needed continuous sub-forms/reports to the form/report at the time it is called.
So here are the questions:
1. Am I on the right track here, or is there some other way to do this, I might not have considered? And,
2. If the latter approach (building the form with vba at the time it is called) is the best way, does anyone know of a good white paper or post that would show me how to do this (I am afraid that I have never done anything like this before)
NOTE: The above post describes creating embedded continuous forms and reports. You can do what I described in a report, but I need to replicate this flexibility for a form as well.
Thanks for your guidance, the help is much appreciated.
Last edited:
