populating a table automatically from a query

D

Dave

Hi,

I have made a query, "QueryMasterList", that pulls data
from 3 tables. Now, I would like to have the query
automatically populate/update a table
called, "TableMasterList" when the user enters data in the
main form. This master table includes all of the 3 tables
fields. What are some ways to do this? Remembering that
the master table would get populated automatically when
the user enters a record in the main form.

Thanks for helping me out!!!
 
P

Pavel Romashkin

Having just a vague understanding of what the user enters, how is that
related to the tables and should it or not have any effect on the
QueryMasterList, I can only suggest that you call the query using DoCmd
or DAO from BeforeUpdate or AfterUpdate event of the form, or create a
command button on the form to call the query. That is, if
QueryMasterList is an append or make table query.

Good luck,
Pavel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Passing a value from subform or main form to subform query 4
Auto populate form fields from table 4
Data entry for a table from a form 1
Open query after close table 1
query search 1
Populating subform based on a selection from master form 1
Lookup Drop down not populating table 5

Top