[AccessD] Filter records in a list via a combo

Hi Brett,
may be I didn't manage to explain what I exactly want to do.
Well, Into a form there are: a text box (txt_names) and a list box
(list_names)
The main table MT_basic_char in which there is the Last_name (about 3
thousand names) is the source of the asking data

When I put the event
Private Sub txt_names_Change()
Me![list_names].RowSource = "SELECT [Last_Name] FROM [MT_basic_char] WHERE
[Last_Name] like '" & Me![txt_names].Text & "'"
End Sub

and begin to write with e.g. the letters kos it should answer with all the
records beginning with "kos" etc etc

Instead of that in the list I see only  ==> SELECT [Last_Name] FROM
[MT_basic_char] WHERE [Last_Name] like 'kos'

Am I doing something wrong?

Thank's all
Kostas Konstantinidis


----- Original Message ----- 
From: "Brett Barabash" <BBarabash at TappeConstruction.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Saturday, May 01, 2004 5:48 PM
Subject: RE: [AccessD] Filter records in a list via a combo


> I don't think so.  When you change the rowsource, it should implicitly
> requery itself since it reruns the query.
>
> OOPS!  Just realized that I was using the wrong property.  It should be
> RowSource, not RecordSource:
> ----------
>      Me!lstMyListBox.RowSource = "SELECT CustomerID, CustomerName FROM
>  Customers " & _
>          "WHERE CustomerName Like '" & Me!txtMyTextbox.Text & "'"
> ----------
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Saturday, May 01, 2004 9:30 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Filter records in a list via a combo
>
> Do you need a Me!lstMyListBox.Requery after the change of row source?
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
>
> ----- Original Message ----- 
> From: "Brett Barabash" <BBarabash at tappeconstruction.com>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Saturday, May 01, 2004 7:21 AM
> Subject: RE: [AccessD] Filter records in a list via a combo
>
>
> > Are you talking about functionality similar to Windows help?
> > In which case, I would use a text box and perform my filtering in the
> Change
> > event:
> >
> > Private Sub txtMyTextbox_Change ()
> >
> >     Me!lstMyListBox.RecordSource = "SELECT CustomerID, CustomerName FROM
> > Customers " & _
> >         "WHERE CustomerName Like '" & Me!txtMyTextbox.Text & "'"
> >
> > End Sub
> >
> > -----Original Message-----
> > From: Kostas Konstantinidis [mailto:kost36 at otenet.gr]
> > Sent: Saturday, May 01, 2004 1:41 AM
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] Filter records in a list via a combo
> >
> >
> > Hi group,
> > I was wondering if it could be possible to filter while writing leter by
> > leter into a
> > combo box to appear the respectively records into a releated list box.
> >
> > Thank's
> > Kostas Konstantinidis
> >
>
> --------------------------------------------------------------------------
------------------------------------------
> The information in this email may contain confidential information that
> is legally privileged. The information is only for the use of the intended
> recipient(s) named above. If you are not the intended recipient(s), you
> are hereby notified that any disclosure, copying, distribution, or the
taking
> of any action in regard to the content of this email is strictly
prohibited.  If
> transmission is incorrect, unclear, or incomplete, please notify the
sender
> immediately. The authorized recipient(s) of this information is/are
prohibited
> from disclosing this information to any other party and is/are required to
> destroy the information after its stated need has been fulfilled.
>
> Any views expressed in this message are those of the individual
> sender, except where the sender specifies and with authority,
> states them to be the views of Tappe Construction Co.
>
> This footer also confirms that this email message has been scanned
> for the presence of computer viruses.Scanning of this message and
> addition of this footer is performed by SurfControl E-mail Filter software
> in conjunction with virus detection software.
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>