TimK01
Technical User
- Jan 4, 2002
- 94
I have a form that displays product details. On that form I have a subform that displays Locations the product can be found at.
On the Subform I have 2 combo boxes, the location and the Aisle at that location
What I want to achieve is that when I select a location, the Aisle combo box select query selects all Available Isles at that location.
This seems to work for the first record in the subform then all subsequebt records select aisles at the location shown on the first record .
So in essence my question is how can I limit the select statement of a combo box to records relating to another field on the same record on the subform.
Thx in advance
Tim
On the Subform I have 2 combo boxes, the location and the Aisle at that location
What I want to achieve is that when I select a location, the Aisle combo box select query selects all Available Isles at that location.
This seems to work for the first record in the subform then all subsequebt records select aisles at the location shown on the first record .
So in essence my question is how can I limit the select statement of a combo box to records relating to another field on the same record on the subform.
Thx in advance
Tim
