update query does not seem to run

[Guest]

I am having trouble with an update query executing. The query only runs when
I go to the objects window and double click on the update query "Reserve
Room". Here is what I have done. I created a table with a check box - checked
(Yes) room is available, unchecked (No) the room is reserved. I have a combo
box in a form bound to that table and when I select a room I want the room to
be removed from the combo box but not deleted from the table. The query works
ok when I double click on the query name. The check box for the room I select
unchecks and when I reopen the form the room is no longer visible in the drop
down list.
What I am trying to accomplish though is to get the query to run and remove
the room from the combo box without having to double click the query in the
query object window. I want to be able to select the room in the combo box
and when I click save the form will close and the query will do the update.
Could someone please tell me how to do this if it needs to have code written
where to enter the code and what the code should be? I have tried to enter
code to run the query in a couple of places but no luck.

 

[Marshall Barton]

I am having trouble with an update query executing. The query only runs when
I go to the objects window and double click on the update query "Reserve
Room". Here is what I have done. I created a table with a check box - checked
(Yes) room is available, unchecked (No) the room is reserved. I have a combo
box in a form bound to that table and when I select a room I want the room to
be removed from the combo box but not deleted from the table. The query works
ok when I double click on the query name. The check box for the room I select
unchecks and when I reopen the form the room is no longer visible in the drop
down list.
What I am trying to accomplish though is to get the query to run and remove
the room from the combo box without having to double click the query in the
query object window. I want to be able to select the room in the combo box
and when I click save the form will close and the query will do the update.
Could someone please tell me how to do this if it needs to have code written
where to enter the code and what the code should be? I have tried to enter
code to run the query in a couple of places but no luck.

I attempted to answer this question in your earlier post.

Please don't post the same question multiple times, it just
clutters the newsgroups and won't get you an answer any
faster.