query to filter on MID(textbox) entered in form

[p-rat]

I have a form and on the form a clerk enters Location such as ABC001.
I also have a combo box that comes from a query. This query has items
from multiple locations where some of the items have same number
(don't ask me why). I want to be able to have this query to be
filtered by MID(Location,1,1). So when they enter the location ABC001
the combo box drop down will only display the items filtered by this.

Right now in the query I have a field that pulls the MID function. On
this field I have criteria = [form]![myform]![textbox100].

The textbox on my is unbound and when visible will display the "A" in
the scenario above. However, when I tab to the combo box and try and
select then I get a display box that asks for [textbox100]. I type
this in and it filters correctly, but I don't want the display box to
show I want this to automatically filter by what the clerk enters in
the beginning.

Thanks.

 

[DStegon via AccessMonster.com]

Can you rewrite your question. Would like to help, but what you have written
does not make a lot of sense.

I have a form and on the form a clerk enters Location such as ABC001.
I also have a combo box that comes from a query. This query has items
from multiple locations where some of the items have same number
(don't ask me why). I want to be able to have this query to be
filtered by MID(Location,1,1). So when they enter the location ABC001
the combo box drop down will only display the items filtered by this.

Right now in the query I have a field that pulls the MID function. On
this field I have criteria = [form]![myform]![textbox100].

The textbox on my is unbound and when visible will display the "A" in
the scenario above. However, when I tab to the combo box and try and
select then I get a display box that asks for [textbox100]. I type
this in and it filters correctly, but I don't want the display box to
show I want this to automatically filter by what the clerk enters in
the beginning.

Thanks.