Calling append query from form

I sure hope someone can help me. I've been struggling all
day now. There's some data that occassionaly needs to be
copied from one record to another and the manual method is
not working so I thought running an append query from a
form and only adding data based on the current records in
my form might help. I have text boxes: OldProduct and
NewProduct they would be criteria inputs to the matching
fields in the table the append query is updating. The
query would be activated by a command button(SaveRecord)
on the form unless there's a better way to do this. I'm
fairly new to Access 2K and don't know much VBA so I'm
stuck. If someone can help me accomplish this I really
appreciate it.

CS wrote:
I sure hope someone can help me. I've been struggling all
day now. There's some data that occassionaly needs to be
copied from one record to another and the manual method is
not working so I thought running an append query from a
form and only adding data based on the current records in
my form might help. I have text boxes: OldProduct and
NewProduct they would be criteria inputs to the matching
fields in the table the append query is updating. The
query would be activated by a command button(SaveRecord)
on the form unless there's a better way to do this. I'm
fairly new to Access 2K and don't know much VBA so I'm
stuck. If someone can help me accomplish this I really
appreciate it.


Create your button, view the properties for it, and on the "Click" event
(under the events tab), click the three dots and choose "Code Builder".
In the code section that comes up, type in:

doCmd OpenQuery "yourQueryHere"

(you will need the quote marks around the name of your query.)

That's all there is to it, unless you need it to get fancy.

Nathan