Creating fields from a table

[Thurls]

Hello all,

I need a form that displays information from a table that is continually having columns added to it. Is there a way that I can automatically generate a new field in the form each time a column is added to the table?

Or is there a way that all the fields in a form can be automatically generated from whats in a table or query at the time the form is opened?

Thanks

Thurls

 

[KenReay]

Hi

If your form is a datasheet view, or if a dataaheet view would do the trick, why not consider scrapping the form and simply opening a query using docmd.openquery

eg

DoCmd.OpenQuery RsT![Argument], acNormal, acReadOnly

see help for syntax

If that will not do for you, then yes you can create controls on a report see CreateControl() in help

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK