Dynamic Forms??

[PaulSpell]

I need to build a form that displays data from a crosstab query.

The problem is that the number (and name) of the columns in the query vary unpredictably from quarter to quarter.

Does anyone know how to get around this other than by dynamically re-creating the form for each enquiry?

(I'm using Access97).

 

[The_Doc_Man]

If the names can change, you cannot build a static definition of these fields. The only thing left is a dynamic form.

If the form is one that would have been in Datasheet view, then perhaps you can open the query itself as a pop-up from the form.

If you actually had a specific screen layout in mind, all you can do is build your form on-the-fly using something that you would build during a Form_Current event. But I'm not that even this would help in AC97.