Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rating: Thread Rating: 9 votes, 5.00 average. Display Modes
Old 09-30-2009, 06:16 PM   #1
Coach Ty
Registered User
 
Join Date: Aug 2009
Posts: 64
Thanks: 0
Thanked 0 Times in 0 Posts
Coach Ty is on a distinguished road
Multiple Table Forms

Hello Everyone,
I've searched for posts regarding this issue and have only found old ones related to prior versions of MS Access.
I'm using Access 2007 and I would like to create one form for data entry into multiple tables. Is this possible?
I've attempted to add the fields from the various tables, however it will only work when the data source is set to one table and will not input information into more than one table.
When the data source is set to multiple tables, it won't allow any data entry at all.
Is my only option to make seperate entry forms for each table or is it possible to create one main form, that will input data into several different tables?
Thanks for your help!

Coach Ty is offline   Reply With Quote
Old 09-30-2009, 10:40 PM   #2
MStef
Newly Registered User
 
Join Date: Oct 2004
Location: Zagreb - Croatia
Posts: 2,251
Thanks: 0
Thanked 82 Times in 75 Posts
MStef will become famous soon enough MStef will become famous soon enough
Re: Multiple Table Forms

Try next:
In Recordset Type properties put ;
Dynaset (Inconsistent Updates)
Look at attachment (word, zip).
Attached Files
File Type: zip updateData.zip (33.3 KB, 236 views)
MStef is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding multiple records to table using form kbomaha Modules & VBA 0 04-16-2009 09:56 AM
2 table query with multiple joins Ron_Mowry Queries 2 03-09-2009 02:55 AM
Continuous forms and querying another table johughes Forms 6 01-24-2006 02:18 PM
Need some suggestions on table layouts chad101 Tables 16 01-08-2006 01:01 PM
Help with Relationships and table design: Bill Harrison Tables 7 01-12-2005 06:44 AM




All times are GMT -8. The time now is 10:57 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World