COPY query

S

Steve.

I have a table that has a unique Key for each row of data. I need a way for
the users to copy a row of data using a query. Is it possible? The
application is contains historical information and the users want to be able
to open a form and then have the option to copy data from a previous record
into the new record. They there are several forms associated with each
record. It would be great if there was a way to prompt for a record id # to
import into the current record.
 
K

KARL DEWEY

Use a form to enter the ID for the desired record and a subform in datasheet
view so as to copy the record by clicking to the left of the leftmost field
and thus highlighting the row of data. Open a data enter form and paste
append.
 
Top