What you need to do is make an after update event in your text box to set the row source of your combo box. Then use the WHERE to filter based on your text box. Something like

ComboName = "SELECT ID From TableT WHERE ID Like """ & TextBoxName & "*"""

Forgot to add ComboName.RowSource not just ComboName

In the Combo Box just use the search as you type code.
That way the Combo Box will not start loading any records until you start typing
Richard shows how to do that somewhere in here.

Kindly can you show me how to do combobox as you type by MACRO and VBA
I will be appreciative

The search as you type is almost identical to what I just told you as long as it's only one field you're sorting by.

This has the search as you type lessons = https://599cd.com/site/courselist/seminars/access-search/

No idea how you'd do it with a macro and I don't even want to try LOL. VBA much easier.

Mr.Adam,
I am enrolled to Access Search Seminars, what is the lesson number?
Because my VBA at my work is blocked for security reasons, that is why if you kindly give it a try by MACRO I will be appreciated

I think it's lesson 33. Search as you Type. You can try to mimic that into a macro or maybe Rick knows a way but I don't know very much about macros. I ditched them the instant I learned VBA.

I did it!
I have text box next to combobox and I go to the combobox query design I put the path that linked to textbox, and if I write something in text box it will filter the combobox,
but the problem is if I hit new record any thing I type still remain in text box how can I say to Access clear textbox after hit add new record or go to next record?

Clear the textbox in the OnCurrent event

TextBoxName = ""

Kevin
OnCurrent event on the form or in control?

OnCurrent is a form event

Kevin,
I go to the Form,OnCurrent Event, Macro, and I chose SetProperty, Control Name, Property Value, Value=""
I put it in Expression Builder same issue =[Searcا1]=""
I could not use VBA becuse it is blocked at work, I can use only Macro,Expression builder, and Query
but it does not work, also in Same form I have more that one control with same job for filtering
Kindly can you explain it more to me

In the Macro Builder:

- Click in the Show All Actions button on the ribbon
- Choose SetValue

Item = TextboxName
Expression = ""