Question Base Combo Box on Parameter Query to Filter Values

[qdata]

Hi all.
I am working on a Database at the moment but I have issues with filtering a combo box from a text box.
What I have in mind is. I have one txt box which states a number e.g. (422).
And I have a combo box which has a list of 270,300,350,400,450,500,550 and 600.
How do I make the combo box only read the numbers less then 422.
Thank you very much for you help.

 

[John Big Booty]

Welcome to the forum.

What you are looking for is a variation on the Cascading Combo Box theme.

So instead of referring to another combo box you will be referring to a text box.

 

[qdata]

Thanks for your help. But what we would like to achieve is that its not pulling up preconfigured values based on 422. Its more like adjusting the combo box so it only shows the numbers which are less what I type in the text box.

 

[John Big Booty]

As I think I mentioned in my previous post it is a variation on the Cascading Combo Box theme.

So instead of using criteria that is equal to the selection of the previous combo box, you would use;

< [Forms]![YourFormName]![YOurTextBoxName]

 

[qdata]

Hi John Big Booty. Thank you very much for your help. We are working on it.