Append query from Form

  • Thread starter Thread starter CS
  • Start date Start date
C

CS

I posted this in the Query forum but haven't had a
response,hopefully someone here can assist me:
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.
 
I posted this in the Query forum but haven't had a
response,hopefully someone here can assist me:
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.
Click to expand...
 
Back
Top