query to filter on MID(textbox) entered in form
- From: p-rat <osupratt@xxxxxxxxx>
- Date: Mon, 23 Mar 2009 07:53:06 -0700 (PDT)
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.
.
- Follow-Ups:
- Re: query to filter on MID(textbox) entered in form
- From: DStegon via AccessMonster.com
- Re: query to filter on MID(textbox) entered in form
- Prev by Date: innertext
- Next by Date: Re: Form to run query based on another query
- Previous by thread: innertext
- Next by thread: Re: query to filter on MID(textbox) entered in form
- Index(es):
Relevant Pages
|
