VBA Dynamic Forms

[pakistranger]

Hi guys, I am trying to create a form or subform that should be created after a button is pressed and some complex filetering is occured and records are saved in a multiple arrays so I need to generate a form and controls according to those array values. Please help.

Actually I can not get data directly out of the query its just too complex bla bla bla. Finally I have three arrays each array has same number of values and I want to generate a form on the basis of the values of the array. Please Help me. I have tried creating form but Could someone please show me the right path.

many thanks

 

[gemma-the-husky]

i think it would be very difficult to base a form on anything other than a query or table.

to use an array you would presumably have to use an unbound form, and then code all your own data management buttons - much much harder

if you can get your data into an array, why can you not get it into a query?