Getting data from forms

  • Thread starter Thread starter BrianC
  • Start date Start date
B

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.
 
See Microsoft Knowledge Base Article # 209261. The title
is deceiving. Read the summary - I think it's what you
want.
 
Back
Top