Using a List or Combo Box to set the value for a Report

[jgrau via AccessMonster.com]

How would you create a report that brings up a list or combo box using a
table that would list the values that you would see.
Example: Each employee has a several skill sets for projects. When you run
the report it would list the 25 skill sets in the skill set table then you
would select one and get the report for who could fill the skill set.

I have it working now but you have to manualy enter the skill set.

There are so many that people can't remember the exact skill set name to type.

 

[Jeff Boyce]

It may be only a matter of terminology ...

A report in Access is a design for a printed output. As such, it doesn't
have (and can't make sense of) a list of values. That said, folks often
want to run a report for a particular value.

The common approach to handling this is to use a form with a combobox that
lists possible values. After the user selects a particular value, s/he
clicks the command button you have on the form, and the code behind the
command button opens the report for the value selected on the form.

Is this what you're trying to accomplish?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[jegrau]

Thank you for your response Yes this is exactly what I am trying to
accomplish. Could you possibly give me an example of the code to use?
--
John E. Grau
IT Specialist
Bureau of Land Managment
Miles City Field Office
Miles City MT 59301
(e-mail address removed)

It may be only a matter of terminology ...

A report in Access is a design for a printed output. As such, it doesn't
have (and can't make sense of) a list of values. That said, folks often
want to run a report for a particular value.

The common approach to handling this is to use a form with a combobox that
lists possible values. After the user selects a particular value, s/he
clicks the command button you have on the form, and the code behind the
command button opens the report for the value selected on the form.

Is this what you're trying to accomplish?

Regards

Jeff Boyce
Microsoft Office/Access MVP