Populating One Dropdown based on the Results of Another

[melih.onvural]

Group,

I'm having a tough time understanding some of the previous posts on
this topic so I wanted to write what I've tried and hope that you can
help me troubleshoot. I have a dropdown populated from a table and I
want to take that selection and use it to populate the next dropdown.
So far:

1) I tried using a query that said select specificissue from
specific_issue and used as my criterion [Form]![Report]![IssueCategory]
but that didn't seem to populate the 2nd dropdown. (Rowsource type was
query)

2) I tried on the On Exit command of the first combo box to use this
statement to populate the second combo box
([OtherCombo].RowSource = "Select AttendYear from YourTableName Where
YourTableName.E vent = " & Me.ThisComboNam e)

3)I've also clicked every button in Access

All help will be appreciated,

Thanks in advance,
Melih

[David W. Fenton]

"Wayne Morgan" <co************ *************** @hotmail.com> wrote in
news:8g******** ********@newssv r19.news.prodig y.com:

I'm not familiar with "this". "Me" is shorthand for the form or
report on which the code is running. . . .
Actually, I think "Me" refers to the class object you're working in.
That's why it works in a standalone class module, since it's a class
object that's unattached to a form or report.
. . . If the form is called
frmMyForm, you would refer to it as Forms!frmMyForm . However, if
the code is in the frmMyForm's module, you can simply say Me
instead of Forms!frmMyForm .

Likewise, when you need to write modular code to act on multiple
forms, you can use the Me keyword to pass a form reference to the
external code. If your external code works like this:

Public Sub SetUpForm(frm As Form)
frm.Detail(0).B ackGroundColor = 0
[and so forth]
End Sub

You'd call it in the form as:

Call SetupForm(Me)

or simply:

SetupForm Me

(I prefer to use Call to show that it's a call to external code, not
a standalone Access command)

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[David W. Fenton]

"Wayne Morgan" <co************ *************** @hotmail.com> wrote in
news:8g******** ********@newssv r19.news.prodig y.com:

I'm not familiar with "this". "Me" is shorthand for the form or
report on which the code is running. . . .
Actually, I think "Me" refers to the class object you're working in.
That's why it works in a standalone class module, since it's a class
object that's unattached to a form or report.
. . . If the form is called
frmMyForm, you would refer to it as Forms!frmMyForm . However, if
the code is in the frmMyForm's module, you can simply say Me
instead of Forms!frmMyForm .

Likewise, when you need to write modular code to act on multiple
forms, you can use the Me keyword to pass a form reference to the
external code. If your external code works like this:

Public Sub SetUpForm(frm As Form)
frm.Detail(0).B ackGroundColor = 0
[and so forth]
End Sub

You'd call it in the form as:

Call SetupForm(Me)

or simply:

SetupForm Me

(I prefer to use Call to show that it's a call to external code, not
a standalone Access command)

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Viviana R via AccessMonster.com]

me***********@g mail.com wrote:

Group,

I'm having a tough time understanding some of the previous posts on
this topic so I wanted to write what I've tried and hope that you can
help me troubleshoot. I have a dropdown populated from a table and I
want to take that selection and use it to populate the next dropdown.
So far:

1) I tried using a query that said select specificissue from
specific_iss ue and used as my criterion [Form]![Report]![IssueCategory]
but that didn't seem to populate the 2nd dropdown. (Rowsource type was
query)

2) I tried on the On Exit command of the first combo box to use this
statement to populate the second combo box
([OtherCombo].RowSource = "Select AttendYear from YourTableName Where
YourTableName. Event = " & Me.ThisComboNam e)

3)I've also clicked every button in Access

All help will be appreciated,

Thanks in advance,
Melih

You have a dropdown where you select a specific field and want to use it to
populate the next dropdown?
1) Your first dropdown should be unbound, and should have a name (go to
properties, other, name).

2) create a second dropdown also unbound, make sure to include the field that
you are selecting in the first dropdown. Also should have a name.
go to propereties and in RowSource click on ... (ellipses).
under the field selected in the first dropdown: Criteria:[first
dropdown name].[value]

3) Make a Macro: RequerySecondDr opdown. Action: Requery

Control Name: Second Dropdown Name

4) First Dropdown go to properties: Event: OnClick: RequerySecondDr opdown

I hope this help Mehli, Good luck
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200507/1

[Viviana R via AccessMonster.com]

me***********@g mail.com wrote:

Group,

I'm having a tough time understanding some of the previous posts on
this topic so I wanted to write what I've tried and hope that you can
help me troubleshoot. I have a dropdown populated from a table and I
want to take that selection and use it to populate the next dropdown.
So far:

1) I tried using a query that said select specificissue from
specific_iss ue and used as my criterion [Form]![Report]![IssueCategory]
but that didn't seem to populate the 2nd dropdown. (Rowsource type was
query)

2) I tried on the On Exit command of the first combo box to use this
statement to populate the second combo box
([OtherCombo].RowSource = "Select AttendYear from YourTableName Where
YourTableName. Event = " & Me.ThisComboNam e)

3)I've also clicked every button in Access

All help will be appreciated,

Thanks in advance,
Melih

You have a dropdown where you select a specific field and want to use it to
populate the next dropdown?
1) Your first dropdown should be unbound, and should have a name (go to
properties, other, name).

2) create a second dropdown also unbound, make sure to include the field that
you are selecting in the first dropdown. Also should have a name.
go to propereties and in RowSource click on ... (ellipses).
under the field selected in the first dropdown: Criteria:[first
dropdown name].[value]

3) Make a Macro: RequerySecondDr opdown. Action: Requery

Control Name: Second Dropdown Name

4) First Dropdown go to properties: Event: OnClick: RequerySecondDr opdown

I hope this help Mehli, Good luck
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200507/1