Getting data from forms

[BrianC]

I have a form called SINGLE BOOKING AVAILABILITY with
three input field called Date, Combo8 and Combo10 and a
command button.

I want to put the values from these fields into a SQL
statement attached to the command button, i.e.

SELECT AVAILABILITY.DATE, AVAILABILITY.PERIOD,
AVAILABILITY.ROOM, AVAILABILITY.BOOKING ID
FROM AVAILABILITY
WHERE (((AVAILABILITY.DATE)=date from form) AND
(AVAILABILITY.PERIOD)=combo8 from form) AND
(AVAILABILITY.ROOM)=combo10 from form));

How do I do this? How do I get the data out of the form
and into my query?

Thanks in advance.

 

[Guest]

See Microsoft Knowledge Base Article # 209261. The title
is deceiving. Read the summary - I think it's what you
want.

 

[Guest]

I'm just using access on a laptop as installed so I assume
this is Jet