By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,400 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

how to show data of a table on a form

P: 86
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
Oct 16 '07 #1
Share this Question
Share on Google+
3 Replies


Jim Doherty
Expert 100+
P: 897
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
Oct 17 '07 #2

P: 86
friend many many thanks. it worked perfectly
Oct 18 '07 #3

Jim Doherty
Expert 100+
P: 897
friend many many thanks. it worked perfectly
You're very welcome :)

Jim
Oct 18 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.