populating a table automatically from a query

  • Thread starter Thread starter Dave
  • Start date Start date
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!!!
 
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
 
Back
Top