[AccessD] Building a search form

Susan,
 
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.

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 

-----Original Message-----
From: Klos, Susan [mailto:Susan.Klos at fldoe.org] 
Sent: Wednesday 2003 Mar 12 07:54
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] Building a search form


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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030312/91d3a877/attachment-0001.html>