<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<META content="MSHTML 5.00.3502.4856" name=GENERATOR></HEAD>
<BODY>
<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></BODY></HTML>