Help with queries

[Brian C]

Hi, I'm a novice Access user in desperate need of help for
a school project.

I have an Availability table with all available
rooms for each period of a school day. I want a teacher to
be able to check availability by looking in the
availability table where a booking id of 1 means
available. Then I want them to enter their details in a
booking form to be entered in a booking table, generate a
booking id (via Autonumber)and have this put in the
availability table to mark that booking as unavailable.

So far I have a form to check availability with command
button to run a query:

DoCmd.OpenQuery "QueryAv"

Where QueryAV is:

SELECT AVAILABILITY.BookingDate, AVAILABILITY.Period,
AVAILABILITY.Room, AVAILABILITY.[Booking ID]
FROM AVAILABILITY
WHERE (((AVAILABILITY.BookingDate)=forms![SINGLE BOOKING
AVAILABILITY]![BookingDate]) AND ((AVAILABILITY.Period)
=forms![SINGLE BOOKING AVAILABILITY]![Combo8]) AND
((AVAILABILITY.Room)=forms![SINGLE BOOKING AVAILABILITY]!
[Combo10]));

which returns the record required and displays it. However
I don't want to display this record.

What I then want to do is check the Booking Id field for 1

If it is 1 then I want to link to another form to create a
record in a BOOKING table which is keyed on Booking Id (as
Autonumber) and then update the record on the AVAILABILITY
table with this Booking Id. So I need to get data from the
second form to update the booking table and then update
the availability table.

Booking Table looks like:

Booking Id
Blocked Booked
Teachers Initials
Set Id
Subject
Date Booking entered

Availability table has the 4 fields above (Booking Date,
Period, Room, Booking Id)

There is a one to many relationship from booking to
availability

How do I not display the interim results?

How do I take data from the second form to update the
booking table?

How do I save the data from the first form so I can then
update it with the booking id?

What is a good solution to this problem?