Re: query to filter on MID(textbox) entered in form
- From: "DStegon via AccessMonster.com" <u50409@uwe>
- Date: Fri, 27 Mar 2009 07:19:59 GMT
Can you rewrite your question. Would like to help, but what you have written
does not make a lot of sense.
p-rat wrote:
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.
--
DS
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200903/1
.
- References:
- query to filter on MID(textbox) entered in form
- From: p-rat
- query to filter on MID(textbox) entered in form
- Prev by Date: Re: Variable not assign when using query as form's record source.
- Next by Date: Re: dlookup error
- Previous by thread: query to filter on MID(textbox) entered in form
- Next by thread: double click event does not triggle on continues sub form
- Index(es):
Relevant Pages
|
