Creating a table on a form

D

DUNNER7

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?
 
J

John W. Vinson

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.
 
D

DUNNER7

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
 
J

John W. Vinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top