Moving Form Data to a Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with customer information drawn from a customer table. The
user then adds comments and a series of checkboxes to unbound items on the
same form. I would like to move all of this information to a temporary table
for further processing. I know I can pick up the information from the
customer table with a query. How do I pick up the rest of the information
from the form? Is there an easy way to either pick all of it up at once, or
pull data from the customer table in and write to the temporary table at the
same time.

Thank you for any help you can provide!
 
Cathy,

Why not have the form controls bound to the relevant fields in the
"further processing" table?

Anyway, to answer your question, you can make an Append Query to move
the data, and in the case of the unbound controls, just reference them
in the Field row of the query design grid using syntax such as...
=[Forms]![NameOfForm]![NameOfControl]
You can include the Customer table in the same query, with appropriate
criteria set, in order to include Customer data into the temporary table
as well.
 
Back
Top