Updating records, Dummy needs a hand. Code Attached.

I was hoping someone could look at this code and give me some direction.

I wrote this for our newsroom to take down info from people reporting school and business closings during snowy weather.

It’s basically a MS Database with 4 tables: Churches, Business, Schools and Daycares.

There are 4 buttons that allow you to select which you are searching.

There is a filter box that runs a query against the table selected whenever you type in the box.

Once you find the entry you are looking for, you can double click the row and it will bring up an edit box with the entry you selected.

Here is where the problem starts. I need to be able to edit and save any changes the user makes in the edit form when they click save.

Everything thus far works great; I just can save any changes!

There has to be a simple trick to saving edited fields back to a table.

Anyone got a second to look and post me a reply.

Thanks everyone!

Hi,
I've had a quick look and made some changes. I think there was some kind
of problem with your data. There is still more work to do but you will get the
gist of it.

Fishy.