populating a form with table.

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

Guest

Hello-
I am going to be vague because I'm very open to any suggestions. I am
importing a table regularly. I want this table to populate a form, I want to
fill in other info on that form. I want the form to populate a completely
different table with all the info on the form. Can I do this? and if so how?
 
Use a Temp table that has the same structure as the destination table,
and a form whose recordset is the temp table. For each import cycle,
import into the temp table, use the form to fill in the rest of the
fields by scrolling through the records, then run an append query which
appends the records in the temp table into the destination table, and a
delete query to clear the records in the temp table so it's ready for
the next import cycle.

HTH,
Nikos
 
Back
Top