Creating Dynamic Forms

[Legion]

I was wondering if it is possible in Access using VBA to create forms dynamically. I have a survey for a course, which is made up of a number of topics, however, the topics change order ie. topic 1 might be taught on day 2 the first time, but the next time the course is taught, topic 1 might be on day 1. However, we don't want to have to change the forms every time we get the next wave of surveys. Is it possible to have the user go first to a batch header form, where they set up the associations, ie. Topic 1 goes with day 1, these two facilitators and phase two. Topic 2 goes with day 3, this facilitator and phase one. After this information is filled in, VBA code would generate the input forms with the topics shown in the current order under the appropriate tabs for phase and day.

 

[Pat Hartman]

If you let data drive the form, you won't need to build new forms for each new survey. Just add sort fields to your tables and use a query sorted on the sort field as the RecordSource for the form.

 

[Legion]

It's kind of hard to explain what I mean. But basically I'm wondering if you could generate forms at run time.

 

[dcx693]

You can store the order of topics in a table and use it in a query to generate your form dynamically. It's not that different in concept from when you have a many-to-many relationship in your data. You have many topics, you also have many different courses to survey. Set up a course table with 3 fields with the topic order. Let the user pick out the correct course order and let the form be based on the selection.