Using a subform to display a table

[jshangkuan]

I posted something earlier before, but I guess my post was not very
clear and I really need help. I have a table1 that has fields F1,F2,F3
and table2 with F1,F4,F5 related by F1. I have another table table3
that I insert the items from a query.

Using VBA code how do I display the contents in table3 in a subform?
Can someone please provide a simple example?

I appreciate the help.

 

[Joseph Meehan]

I posted something earlier before, but I guess my post was not very
clear and I really need help. I have a table1 that has fields
F1,F2,F3 and table2 with F1,F4,F5 related by F1. I have another
table table3 that I insert the items from a query.

Using VBA code how do I display the contents in table3 in a subform?
Can someone please provide a simple example?

I appreciate the help.

A subform of what parent form? How would the table three be related to
the parent form? What relation ship does table three have to table 1 or 2?

 

[jshangkuan]

I guess my question just really is how do I use a form to display the
contents of a table?

 

[Joseph Meehan]

I guess my question just really is how do I use a form to display the
contents of a table?

That is kind of a loaded question. There are thousands of ways. Sort of
how do I draw a picture.

I suggest you can start by using the Form wizard.

Unless you know you will only be using data from one table and you will
be displaying all the data in no particular order, them you may want to
first make a query to select and sort your data. (note: I did say may,
there are other ways)

Northwind is a database that comes with Access as a sample for many
things including reports. It may already be loaded. You can take a look at
it to get some ideas.

I am guessing based on what you have already done, you will be able to
work out things after you get the first version from the wizard.

Hint: If you have problems getting the data to display the way you
want, often it means you have the table(s) improperly designed.