i have a table.
the table columns change from time to time.
i.e they are not constant.
colums may increase or decrease.
i want to show the values of these table on a form.
since the columns are variable,
how can i achieve my requirement?
can any body please help me
Thanq
Simply create a blank form using the design wizard and select "Design View" only. That gives you a blank form in design view with nothing on it.
Now using the toolbox, this time,
without using the wizard (in other words make sure the 'wand' button is not depressed on the toolbox) drop a subform on the form and set its source object property to TABLE.Mytable (where Mytable equals the name of your table) This is the minimum you need to do to achieve what you wish. Now view the form in Form view.
You ought however to consider basing your source object on a QUERY that 'outputs all fields' rather than a table. That way you can set your various sorts options and any other restrictive 'where clauses' directly in the query to display the data you actually wish to see.
You access the properties of a query by right clicking in the various sections of the query design window or using the menubar VIEW...Properties whilst in query design.
The subform will in both cases adjust its columns accordingly when you open the form.
Hope this helps you
Jim