trying to create a copy button??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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.
 
Back
Top