[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
>