Creating a table on a form

I am creating a student database and I have used the Microsoft Access Student
database for some inspiration, but it is not exactly what I need. My student
demographic form is tabed liked the example. I would like to have one of the
tabs represent the information in a table form similiar to the Microsoft
example. How do I get the information from the table to represent itself as
a table on one of my tabed pages of my form?

On Sat, 1 Aug 2009 14:50:01 -0700, DUNNER7
wrote:

I am creating a student database and I have used the Microsoft Access Student
database for some inspiration, but it is not exactly what I need. My student
demographic form is tabed liked the example. I would like to have one of the
tabs represent the information in a table form similiar to the Microsoft
example. How do I get the information from the table to represent itself as
a table on one of my tabed pages of my form?

Create a Subform in datasheet view based on the table.

You can't put "a table" on a form, but you can display the contents of a table
in a form - and use that form as a subform.

--

John W. Vinson [MVP]

You must be everywhere...you always answer my questions!?! Thanks. I have
created a form using my demographic information. I have the student id, last
name, first name fields on the form then I inserted a tabbed form on the
form. I am able to use a tab for each area I want to look at related to each
student. For example one tab may have discipline information, one will have
attendance, etc. How do I create a subform on the tabbed section on the
Primary form??

Thanks

"John W. Vinson" wrote:

On Sat, 1 Aug 2009 14:50:01 -0700, DUNNER7
wrote:

I am creating a student database and I have used the Microsoft Access Student
database for some inspiration, but it is not exactly what I need. My student
demographic form is tabed liked the example. I would like to have one of the
tabs represent the information in a table form similiar to the Microsoft
example. How do I get the information from the table to represent itself as
a table on one of my tabed pages of my form?

Create a Subform in datasheet view based on the table.

You can't put "a table" on a form, but you can display the contents of a table
in a form - and use that form as a subform.

--

John W. Vinson [MVP]

On Sat, 1 Aug 2009 19:09:01 -0700, DUNNER7
wrote:

You must be everywhere...you always answer my questions!?! Thanks. I have
created a form using my demographic information. I have the student id, last
name, first name fields on the form then I inserted a tabbed form on the
form. I am able to use a tab for each area I want to look at related to each
student. For example one tab may have discipline information, one will have
attendance, etc. How do I create a subform on the tabbed section on the
Primary form??

Your tables are correctly normalized, I hope? I know we've discussed them...

You create a Subform control just as you would create any other control: in
form design using the Subform tool on the toolbox. Select the desired tab page
(it should darken) and insert the subform.
--

John W. Vinson [MVP]