How do I limit the values in a combo box using the value from another?

[GICodeWarrior]

I can get the values to be limited but they are statically limited(Are limited the same way all the time and do not change when I switch between records or change the value of the combo box that is doing the limiting) I use the query builder in the properties dialog in the Row Source box to get these results. Is there anyway to make it work the way I want?

 

[moonlight]

You need to refresh the combo box when the value changes Use...

ON Change event use the code

Docmd.Requery "CONTROLNAME"

You could also add this code to the Form's ONCURRENT event, this will requery the combo box on each new record

Hope this helps

 

[GICodeWarrior]

Thank you so much!!! That was exactly what I needed and it worked perfectly. I never would have been able to figure that out on my own.

Thanks again, Code Warrior Burchfield

I write code. See code run. Run code run.