Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Sorting

Status
Not open for further replies.

djnik26

Programmer
Dec 30, 2005
1
US
Hi, I am rather new to Access so bear with me. I need to display a report (for a phone directory database) that shows only the employees from the department which is selected from a combo box. The value of the combo is stored in a string called "departments". I just need to some how make sure the report only shows the employees from the department that is selected. Thanks!
 
Something that takes advantage of the Where property, perhaps?
[tt]DoCmd.OpenReport "rptReport", acViewPreview, , "Department='" & Me.cboDepartment & "'"[/tt]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top