combo box on form with 3 choices....

[CJL]

I have created a form with three pull down seletcions linking 3 tables:
region, property type and specialty. It is set to return all if no choice is
made for a category. The query runs, but it seems to only follow the rule
for the first option, which is region. For example, If I select North
America and leave the other two blank, I get the list for N.A. If I select
one of the other options only, the query gives me everything, ignoring what I
selected. My parameters for my query are: [Forms]![Consultant Query
Form]![Region] & "*" Help?

 

[Jackie L]

Are you requerying the combo boxes after each choice?

For instance, on the AfterUpdate event of your first option, you need to put
Me.NameofSecondOption.Requery
Me.NameofThirdOption.Requery

 

[CJL]

Thanks, Jackie. I did the following:

Private Sub Region_AfterUpdate()
Me.Property_Type.Requery
Me.Firm_Category.Requery

End Sub

It still doesn't sort appropriately. Seems like there must be an easy
solution, but I'm obviously missing something.

Are you requerying the combo boxes after each choice?

For instance, on the AfterUpdate event of your first option, you need to put
Me.NameofSecondOption.Requery
Me.NameofThirdOption.Requery

I have created a form with three pull down seletcions linking 3 tables:
region, property type and specialty. It is set to return all if no choice is
made for a category. The query runs, but it seems to only follow the rule
for the first option, which is region. For example, If I select North
America and leave the other two blank, I get the list for N.A. If I select
one of the other options only, the query gives me everything, ignoring what I
selected. My parameters for my query are: [Forms]![Consultant Query
Form]![Region] & "*" Help?

 

[Jackie L]

First of all, the example you gave in the beginning only shows the first
field as your criteria. Do you need to limit the query by the second and
third fields? What do you mean by sorting appropriately? The sort for the
query should be set up in the query itself. The sort for the combo boxes and
be set in the SQL on the combo box or on a separate query if that is the
source for the drop down.

Can you be more specific on your needs?

Thanks, Jackie. I did the following:

Private Sub Region_AfterUpdate()
Me.Property_Type.Requery
Me.Firm_Category.Requery

End Sub

It still doesn't sort appropriately. Seems like there must be an easy
solution, but I'm obviously missing something.

Are you requerying the combo boxes after each choice?

For instance, on the AfterUpdate event of your first option, you need to put
Me.NameofSecondOption.Requery
Me.NameofThirdOption.Requery

I have created a form with three pull down seletcions linking 3 tables:
region, property type and specialty. It is set to return all if no choice is
made for a category. The query runs, but it seems to only follow the rule
for the first option, which is region. For example, If I select North
America and leave the other two blank, I get the list for N.A. If I select
one of the other options only, the query gives me everything, ignoring what I
selected. My parameters for my query are: [Forms]![Consultant Query
Form]![Region] & "*" Help?