Relationships and subforms issue

[ROL41]

I am creating a form and all the the data entry is via lookups. What I want
to happen is I have created relationships between different groups and when I
select a general topic from one part, I want a subform to open that allows me
to then select the child selections via dropdown menu.

For example, if I have on my main form a selection that has a dropdown named
"foods" and it has selections of "Fruit" and "Vegetables", and someone then
selects fruit, I want a sub form that you can then select from the different
types of just the fruits available, not all the foods as a whole (I don't
want a dropdown that gives me the names of all the fruit and all the
vegetables to choose from, just the fruit). Is there some way that I can do
that, and if so how?

I appreciate any help on this issue.

 

[NetworkTrade]

* When one adds a combo or list box to a form - the wizard prompts as to
which table/query you want it sourced from for look up.

* A query can pull its filtering criteria from a value found on an open
Form's combo/list box.

These two concepts are the key to what you need to implement.

Make your queries. Make an unbound form and add combo/list boxes. Then
tune your queries to filter based on the values entered into the form's
controls.

One presumes the user will enter data in a preset sequence...you can control
that by controlling the visibility of the form's controls perhaps...