copy single record

  • Thread starter Thread starter Evi
  • Start date Start date
E

Evi

You could make the button run an append query which would append that record
onto the required table. BUT I do wonder if there is a good reason why you
need to store a record twice in a database.
Evi
 
I have built a form that users view the contents of two tables joined in a
one-many relationship. As they scroll through the records I would like to
give them a button they can click on that would copy the current record they
are viewing to two other tables built exactly the same way as the main two
tables. Can anyone help me with this one, I can't seem to get this to work.

I have been trying to use the command button wizard to make a single copy of
the record but it puts the copy into the main table, not in the other table
that I need it to go to.

Thank you
 
I tried the Append Query but I'm not sure how to get it to only transfer the
current record only. It wants to append the entire recordset. I don't see
how to set up this as a criteria.

This is only done so we can perform operations on copy's of the original
data so as not to effect the original data
 
I tried running an append query but It wants to append the entire recordset
to the database whereas I just want to append the current record only. I
don't know how to set up the criteria to make this happen.

The only reason we are doing this is so that we can perform operations on
these records that won't effect the original source data.

Thank you
 
I tried running an Append query but it wants to append the whole recordset
to the new table. I only want to append the current record being viewed not
the whole recordset. I don't know how to set up the criteria to make that
happen.

The reason we are putting it into a different table is because we will be
changing the data and we want to keep the original data intact.

thank you
 
Let's say that the field that identifies that record uniquely is called
RecID. Let's say that your form is called MyForm.

In your append query, in the criteria row under the RecID field type:

[Forms]![MyForm]![RecID]

The command button in your form will run this query.


If the record is in a subform then tell me and I'll tell you how to do that.

Evi
 
Thanks Evi, yes, I need to copy data from both a form/table and a
subform/subtable to the same.

Yes, The record I want copied is in both a Form
Evi said:
Let's say that the field that identifies that record uniquely is called
RecID. Let's say that your form is called MyForm.

In your append query, in the criteria row under the RecID field type:

[Forms]![MyForm]![RecID]

The command button in your form will run this query.


If the record is in a subform then tell me and I'll tell you how to do that.

Evi




Charles Pratt said:
I tried running an Append query but it wants to append the whole recordset
to the new table. I only want to append the current record being viewed not
the whole recordset. I don't know how to set up the criteria to make that
happen.

The reason we are putting it into a different table is because we will be
changing the data and we want to keep the original data intact.

thank you
Click to expand...
joined
in like main
two
Click to expand...
Click to expand...
 
Back
Top