Using List Box for Parameter in Form

  • Thread starter Thread starter Diana Chartier
  • Start date Start date
D

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?
 
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
 
Diana, another idea I use:

In the form create a combo box with three fields: JobTitleID, JobTitle and
Description. All three fields are from the underlying table. Create the
combo with the help of the Wizard to select as many table (or query) fields
as you need to include in the combo drop down list. Choose the default to
hide the JobTitleID field from the user and Select the JobTitleID field as
the Bound Column.

Brad H.
 
-----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.
Click to expand...
 
Back
Top