Re: Filter list box by text box
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Sat, 23 Jul 2005 21:12:40 -0500
Edward H via AccessMonster.com wrote:
>I have a query form. The form have many text boxes. I want to use the values
>entered in these text boxes in order to requery my list box. My list box is
>linked to a query that displays all entries in my table.
>Basically, I want to search my table according to the MemID or FirstName or
>LastName. So If I enter a name in the FirstName text box, and click
>FindRecord. I want my list box to display all matching fields.
When the text box(es) must always have a value, you can get
away with simply using a criteria in the list box's row
source query like:
=Forms!nameofform!nameoftextbox
However, when the text box might not have a value, you need
to expand it to:
=Forms!nameofform!nameoftextbox OR
Forms!nameofform!nameoftextbox Is Null
--
Marsh
MVP [MS Access]
.
- References:
- Filter list box by text box
- From: Edward H via AccessMonster.com
- Filter list box by text box
- Prev by Date: Re: Cascading Combo problem.
- Next by Date: Re: Returning invalid use of Null error
- Previous by thread: Filter list box by text box
- Next by thread: RE: Filter list box by text box
- Index(es):
Relevant Pages
|
