Forms!!!

[Paul Bryden]

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]

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]

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~