By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,564 Members | 810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,564 IT Pros & Developers. It's quick & easy.

How to update form information when control source is a query

P: 1
I am very new to developing forms and queries with Access. The task that I am required to complete is as follows:

Build a form based user interface that displays various information from the underlining tables as well as allow for updating of this information. The problem I am having is that all the information that needs to be displaced needs to ‘created’ using a query ie: the form displays information from multiple sets of tables and therefore I am required to use a query as the control source when building the forms. The problem I am having is that I am unaware of how to update the underlining tables with a query. Forms built in functions of adding, saving and deleting work well with tables but do not work when the underlining table is a query, if you understand what I mean? I basically need to know how do I use a form to update, save, and delete information in the various tables when that form is built based on a query. All the tables are linked using appropriate primary and foreign key relationships. Another problem I have is that my coding ability is beyond pathetic! So is there a way to do all of the above using Access built in functions, macros, etc??

Anyone’s help will be extremely appreciated.
Jun 28 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 14,534
You can't put a query behind a form if the query is not updatable. A query that involves joining tables with a one to many relationship would not be updateable.

You need to create a main form based on the main table (the one on the one side of the one to many relationship) and use subforms to add the other tables.
Jul 3 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.