Dropdowns dependent on other dropdown 2

[lholgerg]

I have a dropdown menu that i want to make dependent on another the Row Source date i taken from is.

SELECT [Partner].[Name] From Partner;

I want to make the choices dependent on a field called partners


Hope someone can help

 

[ghubbell]

Thank you Iholgerg. Glad to see sucess! Gord
ghubbell@total.net

 

[JDReece]

Gord,

I have a similar (I think) problem. I have a main form which contains two subforms. Each of the subforms has a dropdown, the first to enter a department name on the first subform, and the second to enter an employee name on the second subform. The difficulty I'm having is that when I select the employee dropdown, I see all of the employees and I would like the list limited to those employees related to the department in the selected record of the first subform. Is there any hope for me?

Thanks John Reece
Manager, Integrated Logistics Support
ITT Gilfillan
Van Nuys, CA

 

[WildHare]

Yes. (just jumping in here.)

Your Employee c/b needs to be based on a query that refers to the DEPARTMENT c/b in its criteria.

In the EMPLOYEE.DEPARTMENT field in the query, in the CRITERIA line, do this:

=Forms!MainForm!subform1-control.Form!combo1

then in the after update event of COMBO1, do this:

Forms!MainForm!subform2-control.Form!Combo2.Requery.

Got that?....




There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm