Drop Down list for a query

[TM]

I just started using Access this month and I am creating a database for the
company I am working for. I have created a query that searches for a job type
if you enter a job division #. Example-> "Enter a division number". You would
then enter a number like the following...01050. I would like to create it so
that the prompt box that shows up is not just a spot to enter a division
number but a list so that they can pick a division number which includes what
the job it is.
Here is an example of 5 different jobs they could choice from: 01050-Surveyors

01106-Architects

16010-Electrical

15010-Mechanical

05230-Welding
When clicking one of the following I would like it to bring up all the
Company's that are in that catergory. I have the division numbers in the
table. If someone could please help me I would really appreciate it. Please
remember though that when you explain that I am new at this and may need it
explain in detail. thank you.

 

[b dubbin]

Sounds to me like you need a combo box.

In your combo box data properties set the 'row source type' t
'Table/Query.'

In the 'Row Source' property enter:

SELECT [your-table-name].[the-field-name] FROM [your-table-name] ORDE
BY [the-field-name];

'your-table-name' is the name of the table containing the differen
jobs.

'the-field-name' should be the name of the field in your table tha
houses the 5 different job examples you listed

 

[TM]

b.dubbin;

The combo box is what i'm looking for but how can i connect it to bringing
up companies that have the job description i selected. It doesn't seem to be
changing the information around it.