Combo box based on combo box requeries subform

[jhiltabidel]

I have a table containing a list of our properties.
I have a table containing a list of computer stations (nodes) AT those properties.

The above information can now be discarded.

I have a table called "Devices" containing lookup information to our properties and the nodes.

I have a form with two combo boxes.
The first combo box shows the list of properties.
The second combo box only shows the list of nodes that are at the property selected by the first combo box.

I need to create a subform.
When I choose a node from the second combo box, I wish the subform to display only the computer inventory (peripherals, monitor, cpu, etc) for that computer station.

I have been able to create the subform itself.

How do I cause the subform "Devices" to only display the information related to the node that appears in combo box # 2 ?

Please reply to: joe.hiltabidel@burroughs-chapin.com

 

[smercer]

I have a table containing a list of our properties.
I have a table containing a list of computer stations (nodes) AT those properties.

The above information can now be discarded.

I have a table called "Devices" containing lookup information to our properties and the nodes.

I have a form with two combo boxes.
The first combo box shows the list of properties.
The second combo box only shows the list of nodes that are at the property selected by the first combo box.

I need to create a subform.
When I choose a node from the second combo box, I wish the subform to display only the computer inventory (peripherals, monitor, cpu, etc) for that computer station.

I have been able to create the subform itself.

How do I cause the subform "Devices" to only display the information related to the node that appears in combo box # 2 ?

Please reply to: joe.hiltabidel@burroughs-chapin.com

the best way for you to do this is to base the subform on a query and the query based on the criteria in the query based on the combo box.

for more help on this see my attachment

PS I have posted here and not emailed you because every one has a simalar problem and a right to receive help.

 

[Bat17]

assuming that there is a field to relate to between the subform and combo box then the wizard should do it for you. If not look at in disgn view and select the two control that you want to link, using "Link Child Field"

Peter