Can a whole subform's field values be copied onto a different subf

  • Thread starter Thread starter Access Non-Pro
  • Start date Start date
A

Access Non-Pro

We have several parallel subforms which have the same fields but different
data sources. Is there an easy way to copy previously entered values from
one subform onto another without copying them one at a time?
 
We have several parallel subforms which have the same fields but different
data sources. Is there an easy way to copy previously entered values from
one subform onto another without copying them one at a time?
Click to expand...

Bear in mind that the data does NOT exist in your subform, nor does a subform
have fields! A form is just a window; it lets you view and edit data stored in
tables, but it does not itself serve as a repository for data.

Your best bet would be to use an Append query to append data from the "various
sources" into your desired target table.
 
Back
Top