Hello:
  I am working on an update query and want to know if there is a way to have it do what I want. Okay, it's a simple update query really. Doing it by hand is easy, I'd just rather make it so I can have anyone do it without entering the query.

Synopsis: I need to update my ISBN's, but they are used in two different tables. So, I can manually run an update query where I have both tables and type in the old ISBN and the New ISBN for both. What I'd like to do is have the query ask what is the old ISBN and what is the new ISBN and have it change it in both tables.

Any thoughts?

Best Regards,
Arholly

I'd throw together a form with two text boxes, old & new, and an update button. On the OnClick event, I would add something like the following:

[Code]
if txtOld = "" OR txtNew="" then
   msgbox "Please make sure you have both and old and a new ISBN entered."
   exit sub
end if

strSQL = "UPDATE Table1 SET ISBN=" & chr(34) & txtNew & chr(34) & " WHERE ISBN=" & chr(34) & txtOld & chr(34)

docmd.setwarnings false
docmd.runsql strSQL

strSQL = "UPDATE Table2 SET ISBN=" & chr(34) & txtNew & chr(34) & " WHERE ISBN=" & chr(34) & txtOld & chr(34)

docmd.runsql strSQL
docmd.setwarnings true
[Code]

Hope that helps... Let me know if you need a hand putting it in place.

Mike




Mike
EchoVue.com

Worked perfectly. Thanks.