2007 Code in 2003

[Kay]

Hi,

I am trying to use Microsoft's code for making a searchable list box using
a text box. I imported the basSearch module; added the event procedures and
changed all references to the listbox and text box code to match my names. I
am referencing DAO 3.6 Object Library. the text box receives the information
from my list box, but the text box does not search the list box based on the
characters I type. Of course, that is the premise of the code. Is there
something else in the code that prohibits it from working in 2003. Your help
is very much appreciated.

Thanks!

 

[Tom van Stiphout]

On Fri, 26 Feb 2010 11:13:01 -0800, Kay

Set breakpoints at the critical functions. Step through the code.

If a function is not called when you think it should, especially an
Event Procedure, it can have become "disconnected" from its control.
Open the Properties window, events tab, and re-select "Event
Procedure".

-Tom.
Microsoft Access MVP

 

[Kay]

Thanks Tom, that is one of the first things I checked. i posted this
problem twice as it took this postiing longer to appear than ususal, so I
thought I had made a mistake in the actual post event. The actual problem is
happening because the list box already has criteria that filters the choices
based on the alpha tab chosen. (Phone Index). I am trying to figure out how
I can get Microsoft's code for usinsg the text box to work alongside the
criteria set in the record source for the list box.

I appreciate your help.

 

[Kay]

Hi all,
I have not had a response to my issue and hope you can help. If you refer
to the discussion below, you will understand that the code I have works
beautifully as written, but because the qry that provides the recordset for
my list box already has criteria that allows it to filter based on the
alphabetic index, it negates my code. The sequel of the list box is as
follows.
SELECT tbltempprovider.OrgID, tbltempprovider.Providers,
tbltempprovider.ReportingState, tbltempprovider.LicenseType,
tbltempprovider.LicenseNumber, tbltempprovider.EntityType FROM
tbltempprovider WHERE (((tbltempprovider.Providers) Like
[forms]![frmSearchDatabase]![txtlastnamefilter] & "*"));