Form/subform w/dropdown information

[ghluvr]

I have a form with at subform which are linked. (I put the plant number in
the form and it automatically inserts in the subform.) The form collects
general data and the subform collects data about a specific piece of
equipment. I want a dropdown in the subform that shows only the specific
pieces of equpment for a specific plant. When I enter the very first plant
number it give me the correct pieces of equipment assigned to that plant in
the drop down. The drop down information is coming from a table I created.

When I want to enter data for a different plant and use the drop down it
still shows me the same pieces of equipment from the first plant I entered.
How can I get it show me only the pieces of equipment for a specific plant
number that I put in from the drop down choices.

I hope I was clear about my problem but it is difficult to explain what is
happening.

Thanks

 

[Fred]

Despite a valiant attempt, you really didn't explain this clearly or provide
the key information. As a minimum, the answerer will need to know what your
table structure is, plus they might need to redesign your table structure.
May I suggest:

- Describe your tables
- Describe the process or informaiton that you are trying to database.

Sincerely,

Fred

 

[Larry Linson]

In Access, a "dropdown" is called a ComboBox. A ComboBox knows where to get
the items in its dropdown list from its RowSource property. If you use a
Query for the RowSource property of your ComboBox, and refer to the Field
identifying the plant, the ComboBox dropdown list Items can be limited to
the ones pertinent to the plant you selected. You may have to use the
Requery method of the ComboBox when the plant changes.

As Fred said, with more detailed description (including Names) of your data
and the controls on your Form, someone might give you a more detailed
answer. But, with good use of Help and posting back here with
clarifications and specific stumbling blocks you've encountered, this should
give you a start.

Larry Linson
Microsoft Office Access MVP