sub forms & combo boxs

[Bob Fitz]

From your post #11

i doint understand how your method can ID to the two fields in the sub form, "area" and "plant type". if i put "area" and "plant type" in the child field i get the from asking for value when i open it do do any thing with it.

Is the form still asking you for a value when it is opened

[clean32]

From your post #11

Is the form still asking you for a value when it is opened

if i have combo0 and combo2 as master

and "area" and "plant type" as child, yes

i get the same asking for data as if you put a ask for data in a query

[Bob Fitz]

if i have combo0 and combo2 as master
and "area" and "plant type" as child, yes

This is what's wrong.
The property settings for Master Link and Child Link should both be the same as I said in post #8


combo0;combo2 for master
combo0;combo2 for child

Please set both to "combo0;combo2" without the quotes and post back with result.

[clean32]

This is what's wrong.
The property settings for Master Link and Child Link should both be the same as I said in post #8


combo0;combo2 for master
combo0;combo2 for child

Please set both to "combo0;combo2" without the quotes and post back with result.

done that before

nothing happens, no filtering no nothing

[Bob Fitz]

Is the form still asking you for a value when it is opened

[clean32]

Is the form still asking you for a value when it is opened

no it only askes me for a value if i have " area" "plant type" in the child fields. it asks twice once for each.

just changed back to combo0;combo2 in both master and child.
i got a winge

the object doesn't contain the automation object "combo0"

[Bob Fitz]

Can you remove any sensitive data and then attach you db to your next post so that I can take a look at it?

[clean32]

sure, but i need a longer message and a smaller DB

[Bob Fitz]

sure, but i need a longer message and a smaller DB

I don't understand what you mean by this.

The file you attached seems to be the wrong db.

[clean32]

"sure, but i need a longer message and a smaller DB"

can not post with a short message and DB no larger than 500K

and your correct wrong DB

Cheers

[Bob Fitz]

Thank you.
I have had a quick look and it seams to work just as I thought it should. Perhaps we should recap exactly what you are trying to do.

At the momment the form opens.
You make a selection from "combo0" and a selection from "combo2".
After the 2nd selection the subform is filled with data.

Is this not what you wanted?

[clean32]

yes

now change one of the combos and see if the data updates, sorry not much there ( data to play with)

[Bob Fitz]

OK

I select "doors" in combo0 and "fixed plant" in combo2.
Subform shows one existing record.

I change the selection to "sliders" in combo0.
Subform changes and shows two existing records.

[clean32]

now change fixed plant to hand tools, there should be no records showing

[Bob Fitz]

Ok

No change in the subform. Now I see your problem.

I think I know how to overcome it. I will have a play with it and post back shortly.