<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=433160414-12032003><FONT color=#0000ff
size=2>Susan,</FONT></SPAN></DIV>
<DIV><SPAN class=433160414-12032003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=433160414-12032003><FONT color=#0000ff size=2>You can set up
almost any combination when you build the SQL. I have a search form that
contains up to 13 variables the user can search on. (Thirteen was all that
fitted on the form neatly.) The user enters values into any of the fields
(and the operator to use, and depending on the operator whether they needed to
enter both a minimum and maximum value or only a single value) they want to use
in the search. When the hit the Search button I then go through each field
to determine if it is selected. If it is I then build the proper SQL
expression for it and add it to the SQL string. When all fields have been
tested and the SQL string completed, it is then executed.</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas Education
Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Klos, Susan
[mailto:Susan.Klos@fldoe.org] <BR><B>Sent:</B> Wednesday 2003 Mar 12
07:54<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> [AccessD]
Building a search form<BR><BR></FONT></DIV>
<DIV><FONT size=2><SPAN class=453504913-12032003>I am creating a FAQ
database. I have the following tables: tblQuestion; tblTopic; tblSource;
tblReference; tblRelationship. I am trying to build a search form that can
be used to find either the Topic, Question, or Question when the Topic is known
(in other words choose the topic first then the questions relating to that topic
show up in the question dropdown. I could do either the Topic or Question
or the Question when the Topic is known. How do I do both on one
form?</SPAN></FONT></DIV></BODY></HTML>