<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=146315916-13022003><FONT face=Arial color=#0000ff size=2>If all
you want is the TopicID and the Topic in the dropdown, then why not just bind it
to tblTopic, set the Column Count to 2, and adjust the Column Width property to
reflect whether or not you want to see both columns or just the Topic
column. Set the Bound Column of the dropdown to 1 and you will be all set
to display the questions in whatever control you choose.</FONT></SPAN></DIV>
<DIV><SPAN class=146315916-13022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=146315916-13022003>
<DIV align=left><FONT face=Arial size=2>Doris Manning</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Database Administrator</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Hargrove Inc.</FONT></DIV>
<DIV align=left><FONT face=Arial color=#0000ff
size=2><U>www.hargroveinc.com</U></FONT></DIV></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com]
<B>On Behalf Of </B>Klos, Susan<BR><B>Sent:</B> Thursday, February 13, 2003
11:37 AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B>
[AccessD] Lookup control on a form<BR><BR></FONT></DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003>I seem to have hit a brick
wall. Hope someone can help. I am trying to create an FAQ database for
use in the office. </SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003>I have a form bound to
tblQuestion</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003> QuestionID
PK</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003> TopicID FK from
tblTopic</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003>I want a dropdown control in
the header that will look up topics in tblTopic and afterupdate find all the
questions on this topic. I need the dropdown control to contain
the topic as well as the TopicID. I tried using the wizard but the
control does not contain the topic unless I bind the form to an SQL statement
that contains both tables. When I use this SQL:</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003>SELECT
tblQuestion.QuestionID, tblQuestion.TopicId, tblTopic.Topic,
tblQuestion.Question, tblQuestion.QuestionerID, tblQuestion.Answer,
tblQuestion.SourceID, tblQuestion.DateAsked, tblQuestion.DateAnswered,
tblQuestion.OtherSourceID, tblQuestion.Reference, tblQuestion.Notes<BR>FROM
tblTopic INNER JOIN tblQuestion ON tblTopic.TopicID =
tblQuestion.TopicId;<BR>And then try to use the wizard to create
the find dropdown I get this error: Syntax error in FROM
clause</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003>If I change the location
of Topic ID i.e. tblTopic.TopicID I get the same
error.</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003>I know I am missing something
basic here, I just can't figure out what it is. </SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003>
</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=937550416-13022003>
</SPAN></FONT></DIV></BLOCKQUOTE></BODY></HTML>