Hi,
I've got a combo box problem...
I have two combo boxes on a continuous form. What I would like to do is to filter the value of my second combo box based on the selected value of my first combo box.
I know how to do this when it's a single form, but for a continuos form.... I've got no clue, as I am pretty much a beginner in access.
I've tried to apply the way for single form to the continuous form, but this does not give me what I need. When I select a value for a record in combo box 1 ALL values for combo box 2 for ALL records are then filtered, while I just need the current record. How can I get this done?
Hopefully the above is clear enough.... can anyone help?
Thnx
RvM
I've got a combo box problem...
I have two combo boxes on a continuous form. What I would like to do is to filter the value of my second combo box based on the selected value of my first combo box.
I know how to do this when it's a single form, but for a continuos form.... I've got no clue, as I am pretty much a beginner in access.
I've tried to apply the way for single form to the continuous form, but this does not give me what I need. When I select a value for a record in combo box 1 ALL values for combo box 2 for ALL records are then filtered, while I just need the current record. How can I get this done?
Hopefully the above is clear enough.... can anyone help?
Thnx
RvM