Form_CascadedCombosOnDatasheets |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 29 Mar 2011 at 12:07am |
Form_CascadedCombosOnDatasheets (Updated On: 07-Apr-2011) Explanatory Notes In a typical arrangement of cascaded bound combo boxes, the first column (bound one - typically the foreign key value) of slave combo box is hidden. As a result, use of filtered row source for the slave combo box on a datasheet or continuous form suffers from the limitation that whenever its row source gets altered as a result of changed value held by master combo box, the displayed values for this column in other records disappear - if the existing real values do not feature in the bound column of lookup list. In order to overcome the problem of blank display in slave combo, the traditional method usually involves one of the following: (a) Placement of a bound text box on top of slave combo box. This technique is applicable only to a continuous form (not feasible in datasheet). This sample db demonstrates an entirely new approach for smooth management of cascaded bound combo boxes on a datasheet or continuous form, without suffering from any of the limitations associated with either of the conventional alternatives mentioned above. There is no need to place any overlapping control on slave combo or to display redundant items in its look up list. This is achieved by binding the slave combo to display field of look up table and storing the foreign key value (fetched through this combo) in a hidden field / column. While such an arrangement exposes the displayable look up field to potential edit action in user interface, care is taken that in reality there is no interference to the values stored in the look up table. Note (For update of 07-Apr-2011): Version: Access 2000 file format. Download >>: uploads/37/Form_CascadedCombosOnDatasheets.zip
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |