Add field to form dynamically

[stephenk1973]

I have a cross tab query for which i cannot be sure what the column header will be. Can i add form field dynamically?

Thanks

Stephen

 

[Pampers]

I think this can be done. Have a look at SmartAccess Sample Publication, the first article has a 'How to Tame the Crosstab Missing Column Beast...'

http://www.pinpub.com/samples/SA_Sample.pdf

Pampers
Keeping it simple can be complicated

 

[MichaelRed]

Better to nTek( iORCE the crosstab columns. Several threads here in these (Tek-Tips) fora, but basically an outer join with a recordset containing the desired clumn names to the piviot field.




MichaelRed