Drop-down not going to default list when closed and reopened
Posted on 2011-10-19
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?