Creating a table on a form

  • Thread starter Thread starter DUNNER7
  • Start date Start date
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?
 
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?
Click to expand...

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.
 
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
 
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??
Click to expand...

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.
 
Back
Top