Retrieving data from subform

[Kenny A.]

I have a form with a subform. The subform is populated via a query. Several
records are returned that relate to the record in the main form. Each of
these records in the subform has a few fields. I need to copy data from 2 of
the fields, and apply this data to a record I am writing to another table in
an update procedure. How can I access the needed data. The record I need to
get in the subform will be the 1st record based on the sort of the query
supplying the data for the subform. Thanks in advance for your help.

Kenny

 

[Jeff Boyce]

Kenny

You've described a "how", as in how you are trying to solve some need.

What will having that data copied into another table allow you to do (this
focuses on the "what"/the need instead)?

I ask because it is uncommon to need to copy data from one table to another
in a well-normalized relational database. It may be that there's another
way to accomplish "what", if we only had a clue ...<g>

Regards

Jeff Boyce
Microsoft Access MVP