Reduce selection

[RussG]

In data entry on a form I want to select from
a combo box so it filters the records in the next combo box accordingly. I.E choose Monday in the first combo box so the second combo box only shows selections relating to Monday and so on.

Thanks in advance

Russ

 

[ElsVanMiert]

1. You set the visible-property of box2 to FALSE
2. On the AfterUpdate-Event of box1 you change the Rowsoure property of box2 according to the choice of box1 and you set the visible-property of box2 to TRUE

Note: The rowsource is simply an SQL string