<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">I have two combo boxes and I’m
trying to limit the contents of the second combo box based on the selection made
in the first box.<SPAN style="mso-spacerun: yes"> </SPAN>I’m obviously
doing something wrong because the second combo box saving the value of the first
box in the table.</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">For the Row Source of the
2<SUP>nd</SUP> <SPAN style="mso-spacerun: yes"> </SPAN>combo box I
have:</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">SELECT ComplaintGeneralCode,
ComplaintSpecificDesc<o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">FROM
tblComplaintSpecific<o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">WHERE ComplaintGeneralCode =
Forms!SF_Complaints_New!cboComplaintGeneral;</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">For the 1<SUP>st</SUP> combo box
I have:</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Private Sub
cboComplaintGeneral_AfterUpdate()<o:p></o:p></P>
<P class=MsoNormal
style="MARGIN: 0in 0in 0pt">Me!cboComplaintSpecific.Requery<o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">End Sub</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face=Arial
size=2></FONT> </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><SPAN
class=801191919-27052003><FONT face=Arial size=2>Table tblComplaintGeneral has
two fields: ComplaintGeneralCode (autonumber), ComplaintGeneralDesc
(text)</FONT></SPAN></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><SPAN
class=801191919-27052003></SPAN><SPAN class=801191919-27052003><FONT face=Arial
size=2>Table tblComplaintSpecific has 3 fields: ComplaintSpecificCode
(autonumber), ComplaintGeneralCode (long integer), ComplaintSpecificDesc
(text)</FONT></SPAN></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><SPAN
class=801191919-27052003></SPAN></o:p> </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">In addition, when I try to close
the form I get a parameter window asking for a value for
Forms!SF_Complaints_New!cboComplaintGeneral</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Any help is greatly
appreciated.</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Ed</P></DIV>
<DIV> </DIV>
<DIV align=left><FONT size=1>Edward P. Tesiny</FONT></DIV>
<DIV align=left><FONT size=1>New York State OASAS</FONT></DIV>
<DIV align=left><FONT size=1>Evaluation and Program Monitoring</FONT></DIV>
<DIV align=left><FONT size=1>1450 Western Ave.</FONT></DIV>
<DIV align=left><FONT size=1>Albany, New York 12203-3526</FONT></DIV>
<DIV align=left><FONT size=1>Phone: (518) 485-7189</FONT></DIV>
<DIV align=left><FONT size=1>Fax: (518) 485-5769</FONT></DIV>
<DIV align=left><FONT size=1>EdTesiny@oasas.state.ny.us</FONT></DIV>
<DIV> </DIV></BODY></HTML>