View Full Version : Forms!!!


Paul Bryden
10-10-2000, 06:49 AM
I qualify all my comments by admitting I am an Access Novice
I am trying to get a form to reference two tables to present all the data.
I have created a seperate tab page and tried to program the new tab box by every time I view the form the box has #Name?. The box is programmed with =[Clean]![Sitename], which is the table I want it to reference.

Please any tips!!

arickards
10-10-2000, 11:48 AM
Try this.
Create a query and add both tables select the fields etc..
Create an inner join, assuming you have a field in both tables that link the records.
Then on the control source of the form use the query.

HTH
ASH~

arickards
10-10-2000, 11:48 AM
Try this.
Create a query and add both tables select the fields etc..
Create an inner join, assuming you have a field in both tables that link the records.
Then on the control source of the form use the query.

HTH
ASH~