Displaying Search Results

hi everyone...

I have a big problem with my VB project that I'm doing now...

first of all I'm doing a very basic database entery for a call center...to record the clients information that we speak with, so I made a form with text entery (mostly like name, phone numbers...etc)
my programme saves perfectly to the database file.
my problem is in searching. I used this code for searching :


the problem is that it does'nt work and I get nothing, all I get is that my form clears up
now what I realy would love to do is that I need to know the best way of displaying a list of results after a search has been performed.
As my application matches records to my search criteria, I would like to list these in a List Box that I have already created and called "lstSearch" and the results should be listed by date "txtDate" so that I can choose from the date and when I press on that date it would fill in my form.
is this possible to do or am I dreaming?

thanks in advance...
peace to all...

Bon jour call center programmer! Though you don't work for our call centers, here you are:

NomM = '*" & txtMNom.Text & "*' ...

Finds all text EQUAL to "*m_lazor*". I believe you don not search for names with asterisks in it, therefore, I think this one will do better:

NomM LIKE '*" & txtMNom.Text & "*' ...

For the second part: Non tu ne reves pas, c'est possible. Faudrait quand-même une description de ce qui est disponible pour accomplir la tâche, p.e. pour la selection selon une date...

By the way: think of giving up the data control, you'll do it anyway lateron

Martin