If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
copy record
I'm using the wizard to create a command button to copy record. It works
fine. How can I exclude the coping of a few fields when I copy the record? Such as field a, b and c. Thanks. |
#2
|
|||
|
|||
copy record
The way the wizard does it will not allow you to do this.
The easiest way to get what you want will be to create an Append query that includes only the fields you want to copy and run the query in the command button's click event. The best command to use when running an Action query (Update, Append, Delete) is: CurrentDb.Execute("MyActionQueryName"), dbFailOnError "rml" wrote: I'm using the wizard to create a command button to copy record. It works fine. How can I exclude the coping of a few fields when I copy the record? Such as field a, b and c. Thanks. |
Thread Tools | |
Display Modes | |
|
|