I am attempting to have a list box generate three different possible list based on what the user picks from a drop down on a field on the same form need help...
Example drop down field 1 , Choices are: key 1, key 2, key 3
if they pick key 2 it would like maybe 6 items, if they picked key 3 it would list 12 items
I set up three different query's which all work and return all the correct items
but when I change the choices for field 1 it still only returns the master list all
THANKS IN ADVANCE