Message for fulfilling previous combo

[Guest]

Hello!

I have sequential comboboxes in form.
I would like to create a message to fulfilling combo, when the user don't to
fill combo immediately previous.

Thanks in advance.
an

 

[Wayne Morgan]

Are you wanting to tell the user that they need to use the previous combo
first? If so, the easiest thing may be to make the dependent combos disabled
until a selection has been made in the earlier combos. This will make the
dependent combos unavailable to the user until they've made a selection in
the earlier combo.

 

[Guest]

WM,
Thanks too for this reply.

Ok. I understand the proposal. But, I ask for excuse for the ignorance, how
to make them dependents, please?

an

 

[Wayne Morgan]

The way you make the later ones dependent on the earlier ones is by using
the earlier ones as criteria for the query in the RowSource of the later
ones.

Example:
If I have a combo box with states and one with cities and I select the state
first, I only want to see which cities are in that state, not every city in
the country. So, to limit the second combo box, the query in the RowSource
would have something like this:

Me.ComboCities.RowSource = "SELECT Cities FROM tblAddresses WHERE State = '"
& [Forms]![MyForm]![ComboStates] & "'"

You would then Requery the ComboCities in the AfterUpdate event of
ComboStates.

 

[Guest]

Thanks, too, for this reply

Here we have a problem. In RowSource already I have:
SELECT DISTINCT Q_PesqMulti.NAI FROM Q_PesqMulti ORDER BY Q_PesqMulti.NAI;

As I will be able, then, to decide the situation?
More one time, been thankful
an

The way you make the later ones dependent on the earlier ones is by using
the earlier ones as criteria for the query in the RowSource of the later
ones.

Example:
If I have a combo box with states and one with cities and I select the state
first, I only want to see which cities are in that state, not every city in
the country. So, to limit the second combo box, the query in the RowSource
would have something like this:

Me.ComboCities.RowSource = "SELECT Cities FROM tblAddresses WHERE State = '"
& [Forms]![MyForm]![ComboStates] & "'"

You would then Requery the ComboCities in the AfterUpdate event of
ComboStates.

--
Wayne Morgan
MS Access MVP

WM,
Thanks too for this reply.

Ok. I understand the proposal. But, I ask for excuse for the ignorance,
how
to make them dependents, please?

 

[Wayne Morgan]

I'm sorry, but I'm having a hard time understanding the exact question.

There is no WHERE clause in query you have listed below. You should be able
to use the same query, just add a WHERE clause that will limit the values
returned depending on the value of the previous combo box or boxes. That
will make this combo box dependent on the value selected in the earlier
combo boxes.

 

[Guest]

WM,

Thanks for your reply.
an

I'm sorry, but I'm having a hard time understanding the exact question.

There is no WHERE clause in query you have listed below. You should be able
to use the same query, just add a WHERE clause that will limit the values
returned depending on the value of the previous combo box or boxes. That
will make this combo box dependent on the value selected in the earlier
combo boxes.