Using combo Box Selection and AfterUpdate Event

[summer01]

I may or may not be using the correct event so that is why I need to ask my question. My combo box is based on the selection of a department name from the tbldepartment.Once selected, the after update event will filter the data and open the correct report from table1, field department. Everything works beautifully, however, I am not sure if there is a way to view all of the records even though there is no department choice of "all". I liked the "After Up-date" so I could go directly to the report as opposed to "on click" where I make a selection, then have to press a Button to get the report I wanted. Is there a way by using the "after update" that I can see ALL the records? Below is an example of my Department Table that feeds the Department field on the primary data table. Also included the "After Update" code:

DeptCode2 Department
Bricktown Brk CS/WI
92650 CS KeyNascoEC
92640 CS Local
Bricktown Indiv Bus
Marketing Marketing


Private Sub cboDept_AfterUpdate()
DoCmd.OpenReport "All Open Issues", acViewPreview, , , acWindowNormal
End Sub

 

[randy700]

Will this help?
How do I add an <All> selection to my combo box drop-down?


Randy