Re: Filtering information in a list box

From: Deb Smith (me_at_mydomain.com)
Date: 06/03/04 

Date: Thu, 3 Jun 2004 15:31:23 -0400

Thanks for the solution! While it works there are some limitations in terms
of my application and the interface with the end-users..

I was wondering if there was another way to accomplish filtering the records
in the list box alphabetically by lname(column1) so that only a limited
number of records display in the list box at a time. Can an option group or
some other button driven method work. I have tried, but have been
unsuccessful.

Also is there a way to make it so that the items in the list box scroll and
correspond to the actual records vs remaining on the original person chosen.

Thanks again for the assistance.
"Wayne Morgan" <comprev_gothroughthenewsgroup@hotmail.com> wrote in message
news:O39n3iXSEHA.3012@tk2msftngp13.phx.gbl...
> Base the Row Source of the listbox on a query. Set the sorting in the
query
> as desired. In the criteria of the query place
>
> Like Forms!frmMyForm!txtMyTextbox & "*"
>
> under the last name field. Add a textbox to the form that the user can
type
> in the first letter (or more if desired) of the last name. In the
> AfterUpdate event of the textbox do a requery on the listbox. The textbox
> will Update when the user presses enter or moves to another control.
>
> Me.lstMyListbox.Requery
>
> --
> Wayne Morgan
> Microsoft Access MVP
>
>
> "Deb Smith" <me@mydomain.com> wrote in message
> news:CbmdnddJO-SUuyLdRVn-tA@igs.net...
> > I have a form with a list box that contains three items
> > (LName,FName,PersonID). Using recordset and Bookmark when you click on
an
> > item in the list box the form's information is automatically populated.
> >
> > There are a large number of records in the list box so scrolling to find
> the
> > appropriate record is cumbersome. I want to filter the records in the
list
> > box alphabetically by lname(column1) so that only a limited number of
> > records display in the list box at a time. For example only records with
> > people with last names starting with "C".
> >
> > I just can't seem to get this to work.
> >
> > Help Please!!
> >
> >
>
>

Loading