Displaying data based on user selections

[s.carter]

I have two cascading combo boxes that the user must select. Based on the selections I want to display two additional fields. For example,
If you choose A and 1 show XX and YY
If you choose A and 2 show XX and XY
If you choose B and 1 show XY and YY
If you choose B and 2 show XX and XX
...

All of this pulls from a 4 column main table
Column 1 = A, B...
Column 2 = 1, 2...


Column 3 = XX, XY...
Column 4 = YY, XY...

Thanks!

[pbaldy]

It sounds like this could work, presuming you add the 3rd and 4th fields to the second combo.

http://www.baldyweb.com/Autofill.htm

[s.carter]

Perfect! I'm almost all set. Now that I have all 4 items pulling on the form. How can I create a clear all button? Once you do a search and all 4 boxes are populated, you can do another search but if the user is distracted and forgets to select the second dropdown they will be looking at the wrong information in text boxes 3 and 4.
I googled "clear all" and "new search" but all the explanations were rather confusing. I saw a video using the button control and the undo feature to clear a form - when I tried it it said it was unavailable.

[pbaldy]

You should be able to set the combos to "" or Null.