trying to create a copy button??

L

lemmein

Hi, Im trying to create a button on a form that will copy one of the fields
from the current record to another table, any ideas how i can do this?

I have tried creating a macro that will runcommands copy and open and paste
but as much as i try whenever i use the copy command it always halts and says
"the command or action copy isnt available now", why wont it copy??
 
O

Ofer Cohen

Why do you need to do that?

If you want to store a caculated field from the form it's not recommanded,
you will be able to get the resault using a query.

To insert records to a table, you can use append SQL
To update existing record, you can use update query SQL

But as I said in the beggining we'll need more details on what you are
tryinh to do.
 
Top