subform drop-down dependancies

[Back2Basics]

Hi



I have a form which has two drop down menus. One of the menus is based on the result of the first menu and so automatically updates based on that selection. To do this I have used - [Forms]![Form_Name]![Drop_Down_1] for the selection of the second drop down list.

This works fine and produces the result I want... until I add it to another form as a subform. Is there a trick to get this to work when using the form as a subform? I have tried changing the name of [Form_Name] to the main form name but this hasn't worked either.

Any help in this would be very much appreciated.

[CJ_London]

instead of [Forms]![Form_Name]![Drop_Down_1]

use
Parent.[Drop_Down_1]

[Back2Basics]

Hi Ajax

Unfortunately this hasn't worked. when I click on the drop down it asks me to 'enter the parameter value' for [Drop_Down_1].

[CJ_London]

until I add it to another form as a subform

you'd better clarify what you mean by 'it'. I assumed it meant from 'One of the menus is based on the result of the first menu' you meant the 'one of' menu

[Back2Basics]

I have created a form called 'frmAppType'. I wish to include this form in the main form, called 'frmNewApp', as a subform. When using 'frmAppType' as a stand alone form it works fine and the drop down menus act as expected. Drop_Down_2 is limited based on what is selected in Drop_Down_1. However, once I add 'frmAppType' to 'frmNewApp' as a subform it no longer works. Drop_Down_1 works fine, but Drop_Down_2 is blank - which is not what I want.

Does that help clear it up?

[CJ_London]

OK, so both dropdowns are on the same form

In which case you do not refer to the forms collection but to the me collection. The reason your code stopped working is that a subform is not part of the forms collection - it is a subform control on the main form

i.e.

me.[Drop_Down_1]

or just

[Drop_Down_1]

[Back2Basics]

Excellent, thanks Ajax.