<div>
Hi,<br />
<br />
you can use the BeforeUpdate event, to refresh or update the next dropdown lists.<br />
<br />
This can be as simple as setting the rowSource property, to calling whatever function used to populate the dropdowns.
</div>


Hi,

you can use the BeforeUpdate event, to refresh or update the next dropdown lists.

This can be as simple as setting the rowSource property, to calling whatever function used to populate the dropdowns.

<div>
Yeap... I was hoping that someone had the actual solution. The rowSource property is a query, as usual. But the query should be dependent on the values of higher level tables and this is precisely what I don't know how to....
</div>


Yeap... I was hoping that someone had the actual solution. The rowSource property is a query, as usual. But the query should be dependent on the values of higher level tables and this is precisely what I don't know how to....

<div>
<div class="content wysiwyg-content">
Hi<br />
On my app o have a 4 level table subtable set for a location: Region / Sector / Section / Base. I need to have the user selecting first the [Region] then, only the [Sector] for the selected [Region] should show on the dropdown [Sector] control, then only the [Section] set for the the selected [Region].[Sector] should show on the dropdown.<br />
All the controls have specific proper names, e.g. &nbsp;[frmfld_Region] for the dropdown control related to Region.<br />
My question is: how do I do it? How do I ensure that the dropdown list is properly managed? (a simple tree as in datasheet view would do ... but I can't simple use it as I loose the &quot;control&quot; management.
</div>
</div>


Hi
On my app o have a 4 level table subtable set for a location: Region / Sector / Section / Base. I need to have the user selecting first the [Region] then, only the [Sector] for the selected [Region] should show on the dropdown [Sector] control, then only the [Section] set for the the selected [Region].[Sector] should show on the dropdown.
All the controls have specific proper names, e.g.  [frmfld_Region] for the dropdown control related to Region.
My question is: how do I do it? How do I ensure that the dropdown list is properly managed? (a simple tree as in datasheet view would do ... but I can't simple use it as I loose the "control" management.

ms/access dynamic source for dropdown control

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.