Form values to Select Query

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hello,
I have a form with multiple sub forms and fields from a
variety of tables. I am basically using combo boxes and
check boxes to indicate the type of information they want
to retrieve. How do I take the information they have
selected on a FORM and input it into a select query? I
am trying to avoid having the user respond to multiple
popup boxes from a select query with [yada yada] as
criteria. Any help will be very appreciated. Thank you.
 
Simple answer:
If you have a textbox named MyText on a form named MyForm, you can write
a SQL statement like this:
SELECT * FROM MyTable WHERE MyField=Forms!MyForm!MyText

That's the beginning -
please post back if you need more than this.

HTH
- Turtle
 
Back
Top