No subject

Where TopicID=[Forms]![Form2]![cmbTopic] Or [Forms]![Form2]![cmbTopic]=0


Then just have the Topics combo requery the question combo.

Drew
-----Original Message-----
From: Klos, Susan [mailto:Susan.Klos at fldoe.org]
Sent: Wednesday, March 12, 2003 11:41 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Building a search form


Drew, my problem with that is the way I synchronize two combo boxes.  Each
is set to a query and I use the ID in the first combo as the criteria for
the query used as a source for the second box.  Now, what criteria do I use
for "all"?

-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com]
Sent: Wednesday, March 12, 2003 11:38 AM
To: ''accessd at databaseadvisors.com' '
Subject: RE: [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?
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com