update query does not seem to run

[Guest]

This may be a dublicate but I don't think my last question got posted:

I am trying to find out how to run an update query automatically. I have a
table of rooms to reserve. In the table I inserted a check box. On my form I
have a combo box bound to the room table and it is set to not show the rooms
if availability (check box) = No. I set up and update query which I don't
know how to link to the combo box if it needs to be, but the query is set to
update the availability to no (uncheck the check box). After I select a room
in the combo box then close the form if I go to the objects window and double
click on the update query "Reserve Room" the check box in the table switches
to unchecked. What I can't get the query to do is run as soon as I click on a
room and save the form. I already went to the query in design form and
clicked on the red exclamation (!) but the query still does not seem to run.
What I need to know is if I have to link the query to the combo box or if I
need to write some VB code. If I need to write some code could you tell me
where it gets inserted and what I need to write. I am new at this and do not
have a working knowledge of VBA. If it is just a link please advise how to
create that link.

 

[Marshall Barton]

This may be a dublicate but I don't think my last question got posted:

[snip third copy of the original querstion]

Patience, Bill. It may take a while for your posts to wind
their way through the myriad of news servers around the
world to get to a server where others (or you) can see it.

While some posts seem to appear in seconds, I have seen
other cases where it took hours for all that to happen so
don't worry about it unless it hasn't shown up by the next
day.