Looking for a recent thread on multple combo boxes

[Guest]

If I skip the 1st combo box selection, the next (2nd, 3rd, etc.) combo box
will
not populate a list. I can't choose from a list in any of my combo boxes
Unless I select each combo box in order. I'm forced to proceed in order
using a method I found at Microsoft help "Basing one combo box on another".

Is there another example someone can show me?

Sometimes I already know what I need in the (2nd, 3rd, etc.) combo box and
would rather save time and start my "drill-down" at the combo box that
applies.

Can I choose from a list in (2nd, 3rd, etc.) combo box and in any order and
then requery and populate a new list for each of the other combo boxes. is
this realistic?

 

[Douglas J Steele]

How are you populating the subsequent ones now? Are you pointing Combo2 to
Forms!MyForm!Combo1? If so, change your condition to also include Or
Forms!MyForm!Combo1 Is Null

 

[Guest]

I don't know which method you used to filter the combo's.
One way to achieve what you are looking for, is to create a filter in the
row source of the combo with reference to the previous combo box

Select FieldName From TableName Where FieldName =
Forms![FormName]![ComboName] Or Forms![FormName]![ComboName] Is Null

============================
The Forms![FormName]![ComboName] Is Null part of the criteria, will display
all the records in the combo if no record is selected in the previous one
============================
On the After update event of each combo, set a requery to the next combo

Me.[ComboName].Requery

 

[Guest]

Originally I did have something similar-->[Forms]![Frmcbox2]![cboMkt]

I've tried the following as my Criteria but it still does not populate the
list in my second combo box.
IIf(IsNull([Forms]![Frmcbox2]![cboMkt]),"",[Forms]![Frmcbox2]![cboMkt])

cboMkt is the name of my first combo box. cboSector is the mane of my
second combobox.

I don't know which method you used to filter the combo's.
One way to achieve what you are looking for, is to create a filter in the
row source of the combo with reference to the previous combo box

Select FieldName From TableName Where FieldName =
Forms![FormName]![ComboName] Or Forms![FormName]![ComboName] Is Null

============================
The Forms![FormName]![ComboName] Is Null part of the criteria, will display
all the records in the combo if no record is selected in the previous one
============================
On the After update event of each combo, set a requery to the next combo

Me.[ComboName].Requery


--
\\// Live Long and Prosper \\//
BS"D

If I skip the 1st combo box selection, the next (2nd, 3rd, etc.) combo box
will
not populate a list. I can't choose from a list in any of my combo boxes
Unless I select each combo box in order. I'm forced to proceed in order
using a method I found at Microsoft help "Basing one combo box on another".

Is there another example someone can show me?

Sometimes I already know what I need in the (2nd, 3rd, etc.) combo box and
would rather save time and start my "drill-down" at the combo box that
applies.

Can I choose from a list in (2nd, 3rd, etc.) combo box and in any order and
then requery and populate a new list for each of the other combo boxes. is
this realistic?

 

[Guest]

It's the wrong criteria, when the first combo is null, then it filter on ""
empty records.

Try

FieldName = [Forms]![Frmcbox2]![cboMkt] Or [Forms]![Frmcbox2]![cboMkt] Is Null

Or Try
FieldName Like
IIf(IsNull([Forms]![Frmcbox2]![cboMkt]),"*",[Forms]![Frmcbox2]![cboMkt])


--
\\// Live Long and Prosper \\//
BS"D

Originally I did have something similar-->[Forms]![Frmcbox2]![cboMkt]

I've tried the following as my Criteria but it still does not populate the
list in my second combo box.
IIf(IsNull([Forms]![Frmcbox2]![cboMkt]),"",[Forms]![Frmcbox2]![cboMkt])

cboMkt is the name of my first combo box. cboSector is the mane of my
second combobox.

I don't know which method you used to filter the combo's.
One way to achieve what you are looking for, is to create a filter in the
row source of the combo with reference to the previous combo box

Select FieldName From TableName Where FieldName =
Forms![FormName]![ComboName] Or Forms![FormName]![ComboName] Is Null

============================
The Forms![FormName]![ComboName] Is Null part of the criteria, will display
all the records in the combo if no record is selected in the previous one
============================
On the After update event of each combo, set a requery to the next combo

Me.[ComboName].Requery


--
\\// Live Long and Prosper \\//
BS"D

If I skip the 1st combo box selection, the next (2nd, 3rd, etc.) combo box
will
not populate a list. I can't choose from a list in any of my combo boxes
Unless I select each combo box in order. I'm forced to proceed in order
using a method I found at Microsoft help "Basing one combo box on another".

Is there another example someone can show me?

Sometimes I already know what I need in the (2nd, 3rd, etc.) combo box and
would rather save time and start my "drill-down" at the combo box that
applies.

Can I choose from a list in (2nd, 3rd, etc.) combo box and in any order and
then requery and populate a new list for each of the other combo boxes. is
this realistic?

 

[Guest]

EXCELLENT...It works. Much, much, much slower now but it works. Let me
quess...as I keep adding more combo boxes that need to requery a list the
slower for will take to populate?

Maybe I could use option buttons for my combo boxes with short list ( 6
items or less). Any ideas?

Thx again for you help.

It's the wrong criteria, when the first combo is null, then it filter on ""
empty records.

Try

FieldName = [Forms]![Frmcbox2]![cboMkt] Or [Forms]![Frmcbox2]![cboMkt] Is Null

Or Try
FieldName Like
IIf(IsNull([Forms]![Frmcbox2]![cboMkt]),"*",[Forms]![Frmcbox2]![cboMkt])


--
\\// Live Long and Prosper \\//
BS"D

Originally I did have something similar-->[Forms]![Frmcbox2]![cboMkt]

I've tried the following as my Criteria but it still does not populate the
list in my second combo box.
IIf(IsNull([Forms]![Frmcbox2]![cboMkt]),"",[Forms]![Frmcbox2]![cboMkt])

cboMkt is the name of my first combo box. cboSector is the mane of my
second combobox.

I don't know which method you used to filter the combo's.
One way to achieve what you are looking for, is to create a filter in the
row source of the combo with reference to the previous combo box

Select FieldName From TableName Where FieldName =
Forms![FormName]![ComboName] Or Forms![FormName]![ComboName] Is Null

============================
The Forms![FormName]![ComboName] Is Null part of the criteria, will display
all the records in the combo if no record is selected in the previous one
============================
On the After update event of each combo, set a requery to the next combo

Me.[ComboName].Requery


--
\\// Live Long and Prosper \\//
BS"D


:

If I skip the 1st combo box selection, the next (2nd, 3rd, etc.) combo box
will
not populate a list. I can't choose from a list in any of my combo boxes
Unless I select each combo box in order. I'm forced to proceed in order
using a method I found at Microsoft help "Basing one combo box on another".

Is there another example someone can show me?

Sometimes I already know what I need in the (2nd, 3rd, etc.) combo box and
would rather save time and start my "drill-down" at the combo box that
applies.

Can I choose from a list in (2nd, 3rd, etc.) combo box and in any order and
then requery and populate a new list for each of the other combo boxes. is
this realistic?

 

[Guest]

When you say slower, you mean to load the form?
Or each combo take while to open?

--
\\// Live Long and Prosper \\//
BS"D

EXCELLENT...It works. Much, much, much slower now but it works. Let me
quess...as I keep adding more combo boxes that need to requery a list the
slower for will take to populate?

Maybe I could use option buttons for my combo boxes with short list ( 6
items or less). Any ideas?

Thx again for you help.

It's the wrong criteria, when the first combo is null, then it filter on ""
empty records.

Try

FieldName = [Forms]![Frmcbox2]![cboMkt] Or [Forms]![Frmcbox2]![cboMkt] Is Null

Or Try
FieldName Like
IIf(IsNull([Forms]![Frmcbox2]![cboMkt]),"*",[Forms]![Frmcbox2]![cboMkt])


--
\\// Live Long and Prosper \\//
BS"D

Originally I did have something similar-->[Forms]![Frmcbox2]![cboMkt]

I've tried the following as my Criteria but it still does not populate the
list in my second combo box.
IIf(IsNull([Forms]![Frmcbox2]![cboMkt]),"",[Forms]![Frmcbox2]![cboMkt])

cboMkt is the name of my first combo box. cboSector is the mane of my
second combobox.

:

I don't know which method you used to filter the combo's.
One way to achieve what you are looking for, is to create a filter in the
row source of the combo with reference to the previous combo box

Select FieldName From TableName Where FieldName =
Forms![FormName]![ComboName] Or Forms![FormName]![ComboName] Is Null

============================
The Forms![FormName]![ComboName] Is Null part of the criteria, will display
all the records in the combo if no record is selected in the previous one
============================
On the After update event of each combo, set a requery to the next combo

Me.[ComboName].Requery


--
\\// Live Long and Prosper \\//
BS"D


:

If I skip the 1st combo box selection, the next (2nd, 3rd, etc.) combo box
will
not populate a list. I can't choose from a list in any of my combo boxes
Unless I select each combo box in order. I'm forced to proceed in order
using a method I found at Microsoft help "Basing one combo box on another".

Is there another example someone can show me?

Sometimes I already know what I need in the (2nd, 3rd, etc.) combo box and
would rather save time and start my "drill-down" at the combo box that
applies.

Can I choose from a list in (2nd, 3rd, etc.) combo box and in any order and
then requery and populate a new list for each of the other combo boxes. is
this realistic?

 

[Guest]

Each combo box takes a while to open.

BTW - I ran a few more test and the 3rd combo box list (and beyond) does not
seem to populate correctly...even if I select them in order. The 2nd combo
box is corret only after 1st combo box is selected. the rest do not seem to
requrey correctly.

Thank you again for you help... I did make some progress though. If I jump
to 2nd, 3rd, etc. as my first choice, the first choice of any combo box seem
to populate correctly....the rest seem to be a mess.

I hope I was clear enough?

Do you know of an example of a form with at least 4 "synchronized" combo
boxes where it does not matter which combo box is selected first? Maybe I
can then see a pattern to follow. the example with only two combo boxes is
not enough.

The end result I want is a "Drill-down" form where a user can skip over any
combo boxes and select any combo box as a starting point to achieve the
desired results from the large database of records.

When you say slower, you mean to load the form?
Or each combo take while to open?

--
\\// Live Long and Prosper \\//
BS"D

EXCELLENT...It works. Much, much, much slower now but it works. Let me
quess...as I keep adding more combo boxes that need to requery a list the
slower for will take to populate?

Maybe I could use option buttons for my combo boxes with short list ( 6
items or less). Any ideas?

Thx again for you help.

It's the wrong criteria, when the first combo is null, then it filter on ""
empty records.

Try

FieldName = [Forms]![Frmcbox2]![cboMkt] Or [Forms]![Frmcbox2]![cboMkt] Is Null

Or Try
FieldName Like
IIf(IsNull([Forms]![Frmcbox2]![cboMkt]),"*",[Forms]![Frmcbox2]![cboMkt])


--
\\// Live Long and Prosper \\//
BS"D


:

Originally I did have something similar-->[Forms]![Frmcbox2]![cboMkt]

I've tried the following as my Criteria but it still does not populate the
list in my second combo box.
IIf(IsNull([Forms]![Frmcbox2]![cboMkt]),"",[Forms]![Frmcbox2]![cboMkt])

cboMkt is the name of my first combo box. cboSector is the mane of my
second combobox.

:

I don't know which method you used to filter the combo's.
One way to achieve what you are looking for, is to create a filter in the
row source of the combo with reference to the previous combo box

Select FieldName From TableName Where FieldName =
Forms![FormName]![ComboName] Or Forms![FormName]![ComboName] Is Null

============================
The Forms![FormName]![ComboName] Is Null part of the criteria, will display
all the records in the combo if no record is selected in the previous one
============================
On the After update event of each combo, set a requery to the next combo

Me.[ComboName].Requery


--
\\// Live Long and Prosper \\//
BS"D


:

If I skip the 1st combo box selection, the next (2nd, 3rd, etc.) combo box
will
not populate a list. I can't choose from a list in any of my combo boxes
Unless I select each combo box in order. I'm forced to proceed in order
using a method I found at Microsoft help "Basing one combo box on another".

Is there another example someone can show me?

Sometimes I already know what I need in the (2nd, 3rd, etc.) combo box and
would rather save time and start my "drill-down" at the combo box that
applies.

Can I choose from a list in (2nd, 3rd, etc.) combo box and in any order and
then requery and populate a new list for each of the other combo boxes. is
this realistic?