Using List Box for Parameter in Form

[Diana Chartier]

Question: An employee opens a form to select the
competencies for a specific job title. The employee does
not have access to the tables in the database nor do they
know the exact wording of the job title. How would I
create a drop down list to act as a parameter for the job
title field in either the query or the form?

 

[Yair Sageev]

The job-title combo box should be populated so that the user can select the
appropriate job title. If the user has no idea what the job title is than
nothing will help. You can easily populate the combo box by using the
wizard and selecting the column of job titles in the appropriate table. You
can also do this via the properties without the wizard.

After the user selects the job title from the list, the user can open a
pop-up form linked to the job-title form by job-title. In that form the
user selects the competencies. Be sure to update the parent form before you
open the pop-up form or the link may fail.

HTH

 

[Marty Suckstorff]

-----Original Message-----
Question: An employee opens a form to select the
competencies for a specific job title. The employee does
not have access to the tables in the database nor do they
know the exact wording of the job title. How would I
create a drop down list to act as a parameter for the job
title field in either the query or the form?
.
Use a combo box for this instead of a list box.