[AccessD] Building a search form

Hmmmm, why not just have two combos, Topic and Question.  Have an 'all' in
the Topic question, so that you can either select a Topic (and on the
Onclick requery the Question combo based on the Topic selection), or a
question.

Drew

-----Original Message-----
From: Klos, Susan
To: 'accessd at databaseadvisors.com'
Sent: 3/12/03 7:54 AM
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?