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?

 

[LonnieJohnson]

Are you getting the values from a table for the second box or, do you have a list?

Try setting the row source for the second combo box using a VB statement in the first combo box's After Update event.

B-) ljprodev@yahoo.com
ProDev
MS Access Applications