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?

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.
 

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

Back
Top