How to update form information when control source is a query

[mdk7]

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.

[MMcCarthy]

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.