Showing part of the combobox values when button is clicked

[TallSA]

Hi All,



I have combobox in different forms in my database show these values (-4,0,2w,1,2,...,36). I would like to be able to show only part of these values when button is clicked. for example, in my main form if I clicked (-4 button) I would like to see only -4 in the combobox, and if I clicked (1,3,5,7 button) I would like to see only these values (1,3,5,7) in the combobox.


Thank you for your help in advance.

Regards,

[ranman256]

this makes no sense. the whole point of the combo box is to pick the value.
Now you want to pick a value (from a button) to then pick the value from the combo too. (double the work)
you dont need the button.
or
a double combo,
like picking a state in the box
then pick the city of that state in another box.
is this what you need?
for this you want 2 combos, using queries. Buttons cant use queries.

[TallSA]

Hi Ranman256

Thank you for your reply.

When you click on the button, it open series of forms, with the combobox in these forms (so not double the work as you stated).

I would just like to make it easier to the user not to go through all the combobox values, instead go through only the values that he only needed now.

Regards,

[orange]

Why don't you adjust the rowsource of the combo based on the form being opened?

[TallSA]

Hi Orange,

Do you mean that, creating different queries for the rowsource based of the form being opened?

[orange]

Yes, or, depending on what you are doing/need, you could alter the criteria to show only those data relevant to the current situation.

[TallSA]

How can alter the criteria to show only those data relevant to the current situation?

[orange]

Only you know what you're trying to do.
There are several combobox tutorials here. Take a look and see if any apply to you.