Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How To Connect More Than One Table To A Form, Access 2007

Status
Not open for further replies.

David92595

IS-IT--Management
Jul 13, 2012
12
US
Hello,

Basics: I'm running a SQL server 2008 R2 back end with an Access 2007 Front end.

I need to find a way of opening up a form that is joined to more than one table in the backend. The users have to be able to enter information and update the corresponding tables with the new data in the form (Not a view only form).
For the more literal types, I need to connect our main table with a new table I just created. Our main table holds all of our ID #’s and other fields we need to display on the page, but we also need it to hold new fields for data entry to our new table as well.

As always, any help is greatly appreciated,

David92595
 
hi,

You might get better results in forum702.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top