combo box selection to change subform

[Guest]

Hey Guys,

I have a form, which has a combo box in it...

I also have a subform which lists the assets we have..

I would like the subform to only show assets which match the selected combo
box selection on click..

How can I do this?

 

[Arvin Meyer [MVP]]

An example using list boxes to drill data down is at:

http://www.accessmvp.com/Arvin/Combo.zip

 

[Guest]

I don't understand this one.. It gives the details in a list box, I've got it
as a subform in mine..

All I want is so when I select a specific setting it lists only those
matching it in the subform.

 

[Ron2006]

I don't understand this one.. It gives the details in a list box, I've got it
as a subform in mine..

All I want is so when I select a specific setting it lists only those
matching it in the subform.






- Show quoted text -

The concept is the same,
The source for the list box is a query and in the example the criteria
is the selection from the combo box.

The source for your subform is a query, and what is necessary is that
you put in criteria that points to the combo box.

OR

1) On the Main Form place a hidden field perhaps called
hldMYMatchField.
2) In the Afterupdate event of the combobox
forms![MainForm]![hldMYMatchField] =
me.MYMatchFieldName


3) In the design mode of subform for the form itself place
LinkMaster as [hldMYMatchField]
LinkChild as [name of my Match field in that table/
query]


You have to do it by hand because the wizard for linking the tables
will not function. But it is the wizard that does not work...the
actual linking will work.


Ron

 

[Arvin Meyer [MVP]]

You will notice the code in the list box requeries the row source query of
the second list box. It is identical to requerying the recordsource query
for a subform.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[tnahowru]

i downloaded the combo database but there seems to be an error, try to open
up the form frmProducts and see the errors.

This is where i need help because i followed the sample so now i'm gettin
the same errors.

Thnak you.