Search Form & Telephone Numbers in text fields

[colenzo]

Hi All,



I've used a fairly common set of code to create a dynamic multiple field search form, and have changed all the parameters to the database i have constructed, however, it doesn't appear to:

1. want to search
2. pop up the record in the original entry form

I've zipped up the database, could someone have a look for me and point me in the right direction as I really am pulling my hair out now, and I have no clue how to fix it! I'm not in anyway knowledgeable with access and tend to get these tasks dumped on me in-between my regular workload!

Something is telling me it's because I'm looking to search for a telephone number in a text field. And yes, I know this is backward: if anyone has a better suggestion then that's fine as long as you let me know how on earth I can search that specific field as well!

Thanks

[ItsMe]

Here is an example of using the On Change event handler to search a listbox. I looked at your code and don't really see any searching going on in your example.

[colenzo]

Yeah..... thank-you but it didn't work either.

Ironically, I have the same code in another database I have created that works perfectly as a dynamic search code. It just doesn't seem to be working for this particular database.

[ItsMe]

I took another look at the DB. The list box gets its Rowsource from a query. The query is a paramiterized query based on an unbound textbox in the form. The unbound textbox (the one that supports the query) gets its data from another unbound textbox.

When the user types into the textbox provided, the list box RowSource changes.

What is it that is not working for you? What do you want to happen when the user types into the textbox?