469,602 Members | 1,686 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Auto populate combo box range based upon previous selection

Hello All,

I am a new user to Access. I am currently designing a database
consisting of four tables for multiple users. Rather than bore you
with the goals and such, here is what I am attempting to do:
I have two combo boxes, the first of which contains three text values
(Org 1, Org 2, Org 3) and the second combo box contains a listing of
30 or so clients. I would like to condense the second combo box based
upon the selection of the organization in the first combo box.

For example, if I select "Org 2", I would like it to show the roughly
10 clients that are associated with Org 2 rather than the other 20
clients which do not pertain to that org.

Thanks in advance for the help. Please remember I am a new user to
Access. I realized after reading this forum I will probably be
redesigning soon but would like to solve this issue while it is top of
mind.

Mar 26 '07 #1
3 7647
There are many ways to skin this cat. Set the source for cb2 to
include a filter on Org where Org =cb1.value. Then requery cb2 when
you change the selected value in cb1. That should be one way to
accomplish it.
On Mar 26, 2:49 pm, joseph.mccastl...@gmail.com wrote:
Hello All,

I am a new user to Access. I am currently designing a database
consisting of four tables for multiple users. Rather than bore you
with the goals and such, here is what I am attempting to do:
I have two combo boxes, the first of which contains three text values
(Org 1, Org 2, Org 3) and the second combo box contains a listing of
30 or so clients. I would like to condense the second combo box based
upon the selection of the organization in the first combo box.

For example, if I select "Org 2", I would like it to show the roughly
10 clients that are associated with Org 2 rather than the other 20
clients which do not pertain to that org.

Thanks in advance for the help. Please remember I am a new user to
Access. I realized after reading this forum I will probably be
redesigning soon but would like to solve this issue while it is top of
mind.

Mar 26 '07 #2
On 26 Mar 2007 11:49:35 -0700, jo***************@gmail.com wrote:
Hello All,

I am a new user to Access. I am currently designing a database
consisting of four tables for multiple users. Rather than bore you
with the goals and such, here is what I am attempting to do:
I have two combo boxes, the first of which contains three text values
(Org 1, Org 2, Org 3) and the second combo box contains a listing of
30 or so clients. I would like to condense the second combo box based
upon the selection of the organization in the first combo box.

For example, if I select "Org 2", I would like it to show the roughly
10 clients that are associated with Org 2 rather than the other 20
clients which do not pertain to that org.

Thanks in advance for the help. Please remember I am a new user to
Access. I realized after reading this forum I will probably be
redesigning soon but would like to solve this issue while it is top of
mind.
Leave the Rowsource property of the second Combo Box blank.

Code the AfterUpdate event of the Combo1 to something like this:

Me![Combo2].Rowsource = "Select TableName.[ClientName] From TableName
Where TableName.Organization = '" & Me![Combo1] & "' Order By
[ClientName];"

This assumes the bound column of Combo1 is Text datatype, not Number.

Change the Table and Field names as needed.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Mar 26 '07 #3
Same cat, different knife! :)

On Mar 26, 3:19 pm, fredg <fgutk...@example.invalidwrote:
On 26 Mar 2007 11:49:35 -0700, joseph.mccastl...@gmail.com wrote:


Hello All,
I am a new user to Access. I am currently designing a database
consisting of four tables for multiple users. Rather than bore you
with the goals and such, here is what I am attempting to do:
I have two combo boxes, the first of which contains three text values
(Org 1, Org 2, Org 3) and the second combo box contains a listing of
30 or so clients. I would like to condense the second combo box based
upon the selection of the organization in the first combo box.
For example, if I select "Org 2", I would like it to show the roughly
10 clients that are associated with Org 2 rather than the other 20
clients which do not pertain to that org.
Thanks in advance for the help. Please remember I am a new user to
Access. I realized after reading this forum I will probably be
redesigning soon but would like to solve this issue while it is top of
mind.

Leave the Rowsource property of the second Combo Box blank.

Code the AfterUpdate event of the Combo1 to something like this:

Me![Combo2].Rowsource = "Select TableName.[ClientName] From TableName
Where TableName.Organization = '" & Me![Combo1] & "' Order By
[ClientName];"

This assumes the bound column of Combo1 is Text datatype, not Number.

Change the Table and Field names as needed.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -

- Show quoted text -

Mar 26 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Alex | last post: by
1 post views Thread by Jim | last post: by
reply views Thread by dudeja.rajat | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.