How to "Paste" copy of a Record as a New Record ?

[Will]

I thought I could "copy" a record...

and then "paste" it in as a new record...

then change certain fields as necessary.

But it doesn't seem to work.

How can I do this?


thanks for any help.

 

[fredg]

I thought I could "copy" a record...

and then "paste" it in as a new record...

then change certain fields as necessary.

But it doesn't seem to work.

How can I do this?

thanks for any help.

Words like "doesn't seem to work" are not very helpful.
What does it do? What does it not do? etc., are better.

Try Edit + Select Record then Copy then Paste Append
Does that work for you?

 

[Will]

Here is the message Access gives me when I try to Select/Copy a record and
then Paste/append...

"The current field must match the join key 'tblProducts.idProduct' in the
table that serves as the 'one' side of one-to-many relationship. Enter a
record in the 'one' side table with the desired key value, and than make the
entry with the desired join key in the 'many-only' table."

When I manually fill in all the fields it works fine.

Is this because the query the form is built on has data from multiple
tables?

How can I fix it?

thanks for any help.

Will

 

[Ed]

I use to copy - paste and it worked ok for me. My form had many tables. I
now use an append query. works much better because the fields you want to
set not same as previous record can be set to anything you want for defaults
or left blank. also works better with autonumber id fields and dates etc..

 

[Gina Whipp]

In the query sounds like a relationship problem. Sounds like you are trying
to enter a record on the many side and there is no corresponding record on
the one side. BUT when you many enter it it finds the corresponding record
on the one side. I would start by checking the query AND if you sre doing
this thru a form the fields on the form.