queries/parameters/combo box

[Guest]

Hello -

I import an expense account file from an outside source that I use to create
reports in Access.
For each of the accounts I've created queries with parameters for the dates
for the user to enter to generate the report.
The records have the employees name in each record. Now my question. How
can I create a drop down list in the parameter area that lists the employee
name only once so that the user can choose an employee on which to base the
report.

I'm not experienced with VB, so I hope any suggestions can be accomplished
within 'regular access'

Thank you all.

Marc

 

[Douglas J. Steele]

Create a form with a combo box that has the information the way you would
for anything else.

Have your query reference that combo box, rather than a generic parameter
like [What Employee Name?]

Put a button on your form to open the report (when your query references a
query on a form, the form must be open for the query to work properly)

 

[Lynn Trapp]

Hi Marc,
1. Create a form with a combobox that has the employee names as the record
source.

Select Distinct EmployeeName
From YourEmployeeTable;

2. Base your report on a query that uses your combobox as a criteria.

=Forms!YourFormName!YourComboBox

3. Put a button on the form to call the report. The wizard can help you
create the button.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html