Using an Event Procedure to run an Update Query from a Form

[kiermarie]

I have created an Update Query to modify information in a table. The query works, according to my tests.

So that I wouldn't have to remember to run the query everytime I updated a certain field I wanted to create an "After Update" Event Procedure, connected to a check box. Because I didn't know all the syntax for this process I created a Command Button using the wizard and then copied the syntax into the code builder, replacing the references to the command button with references to the check box. Presumably, then, my syntax is correct since I copied it straight from the wizard.

OK, after all the background here's my question: When I went to the form and clicked (updated) the check box it did "run" the query, but when I went to the table which the query is supposed to modify, the data had not been changed. Why would this happen? The query updates the table when I run it manually, but the event procedure telling the check box to run the query after update does not update the table.

Please help!

 

[Shep]

I followed the same steps you took and it works fine for me.

Let's see your update query SQL and the code behind your check box.

 

[kiermarie]

I feel so dumb. The problem was that the query was open. I closed the query and it worked fine. Thanks for your reply.

 

[Shep]

You're welcome, and don't let it bother you. It happens to most folks from time to time.