<div>
Thank you, &nbsp;in testing, it seems to be working now.<br />
<br />
Sandra
</div>


Thank you,  in testing, it seems to be working now.

Sandra

<div>
<div class="content wysiwyg-content">
I have a form that has a drop-down for alist of projects. &nbsp;When the form opens, the drop-down should show all projects. &nbsp;there is also on the form a drop-down showing user from which a user can be selected, then the Project drop-down is change to only reflect the projects for that user. &nbsp;However, sometimes, when the form is closed, rather than reverting to all projects, it keeps the last listing. &nbsp;Say I have Select PRojectID FROM tblProjects, but whent the user decides to filter for only one person, the statemetn changes to SELECT ProjectID FROM tblProjects where ProjectAssignedTo = 'SMITH'. &nbsp;So, how to I ensure that when the form opens, the project dro-down is always SELECT PROJECTID from tblProjects, with no filter?
</div>
</div>


I have a form that has a drop-down for alist of projects.  When the form opens, the drop-down should show all projects.  there is also on the form a drop-down showing user from which a user can be selected, then the Project drop-down is change to only reflect the projects for that user.  However, sometimes, when the form is closed, rather than reverting to all projects, it keeps the last listing.  Say I have Select PRojectID FROM tblProjects, but whent the user decides to filter for only one person, the statemetn changes to SELECT ProjectID FROM tblProjects where ProjectAssignedTo = 'SMITH'.  So, how to I ensure that when the form opens, the project dro-down is always SELECT PROJECTID from tblProjects, with no filter?

Drop-down not going to default list when closed and reopened

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

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.