Link to home
Create AccountLog in
Avatar of João serras-pereira
João serras-pereiraFlag for Portugal

asked on

ms/access dynamic source for dropdown control

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.
Avatar of Fabrice Lambert
Fabrice Lambert
Flag of France image

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.
Avatar of João serras-pereira

ASKER

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....
ASKER CERTIFIED SOLUTION
Avatar of Fabrice Lambert
Fabrice Lambert
Flag of France image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
thanks!!! great HELP!