Criteria and IIf in Search Page

[papadega3000]

I have a form with drop down boxes that list 3 related fields and I have a search button that will requery based on the the input from these boxes. These boxes are all prepopulated with the data and I want to be able to select something from Box1 and then based off Box1 change whats populated in Box2 and Box3. Any idea's???

I already have a query setup like this to requery a query I make:
( I have a button that initiates the requery based off what input is given)
Box1:

IIf(IsNull([Forms]![FormName]![Combo1]),[Field1],[Forms]![FormName]![Combo1])

Box2:
IIf(IsNull([Forms]![FormName]![Combo2]),[Field2],[Forms]![FormName]![Combo2])

Box3:
IIf(IsNull([Forms]![FormName]![Combo3]),[Field3],[Forms]![FormName]![Combo3])

Problem with this is that is does not requery correctly and it only filters on one of the criteria ( Field1) and spits out all records for the other two?

So I figured since I already populate the drop downs with the records why not just change the contents of the drop downs?
If anyone can give me some insight it would be much appreciated?

Thanks in advance.

 

[jdraw]

I have a form with drop down boxes that list 3 related fields and I have a search button that will requery based on the the input from these boxes. These boxes are all prepopulated with the data and I want to be able to select something from Box1 and then based off Box1 change whats populated in Box2 and Box3. Any idea's???

I already have a query setup like this to requery a query I make:
( I have a button that initiates the requery based off what input is given)
Box1:

IIf(IsNull([Forms]![FormName]![Combo1]),[Field1],[Forms]![FormName]![Combo1])

Box2:
IIf(IsNull([Forms]![FormName]![Combo2]),[Field2],[Forms]![FormName]![Combo2])

Box3:
IIf(IsNull([Forms]![FormName]![Combo3]),[Field3],[Forms]![FormName]![Combo3])

Problem with this is that is does not requery correctly and it only filters on one of the criteria ( Field1) and spits out all records for the other two?

So I figured since I already populate the drop downs with the records why not just change the contents of the drop downs?
If anyone can give me some insight it would be much appreciated?

Thanks in advance.

You might look at this post, it seems somewhat similar.

http://www.access-programmers.co.uk...p=683730&highlight=cascading+combo#post683730

 

[papadega3000]

Thanks for the link. I just browsed it real quick and it appears to be exactly what I am looking to accomplish.
I will give it a shot and see what happens.

 

[papadega3000]

I have successfully implemented what I needed to accomplish from the links you sent me. It took a tiny bit of tweaking but I figured it out.

Thanks for your input.