<div>
Also, if the one combo box feeds another, you can be real slick and move the focus to the second one...<br />
<br />
Me.Project.SetFocus<br />
Me.Project.DropDown
</div>


Also, if the one combo box feeds another, you can be real slick and move the focus to the second one...

Me.Project.SetFocus
Me.Project.DropDown

<div>
Thank you, both features worked Awesome :-)
</div>


Thank you, both features worked Awesome :-)

<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the grade.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
Here is my Code for my cascading combo boxes in Access, all I want to do is sort by Project in my second combo box. &nbsp;Order by is not working.....<br />
<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />--------<br />
Private Sub ProjectType_AfterUpdate()<br />
<br />
Me.Project.RowSource = &quot;&nbsp;SELECT ProjectID,Project, ProjectTypeID&quot; _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&amp; &quot;&nbsp;FROM tblProjects&quot; _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&amp; &quot;&nbsp;WHERE ProjectTypeID=&quot; &amp;&nbsp;Me.ProjectType &nbsp;<br />
End Sub<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />
</div>
</div>


Here is my Code for my cascading combo boxes in Access, all I want to do is sort by Project in my second combo box.  Order by is not working.....

----------------------------------------------------------------------------------------------
Private Sub ProjectType_AfterUpdate()

Me.Project.RowSource = " SELECT ProjectID,Project, ProjectTypeID" _
                       & " FROM tblProjects" _
                       & " WHERE ProjectTypeID=" & Me.ProjectType  
End Sub
------------------------------------------------------------------------------------------------

ORDER BY in Cascading Combo Boxes in Access 2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.