Combobox Search with LIKE

[Pascal Hagedorn]

Hello Alltogether, following problem is bugging me :)

I am havin a Combobox where i can browse and select my articles. So far so
good!

Over the time my table "article" growed and now it is not very conveniant to
search for articles, the name you dont know exactly

Now i would like to realise the same Combobox with a Select statement over
the same table "article" as follows:
SELECT article.* FROM article WHERE (((article.articleName) Like "*" &
Me!Combobox & "*")) ORDER BY article.articleName;

As you can see, this sql statement looks for the entered string in the
column articleName and if it is part of any article. (if i enter "er" it
will show up "hamster" as well as "ernie" and "bertie") :)

Trying to actualize the table "after actualisation" with Me!Combobox.requery
is not working :/

I am turning myself round and round! But maybe one of you could stop ;) ....
thank and if you need further information about my problem, please let me
know!

[DavidB]

Perhaps part of the problem is that your SQL has left out a pair of
single quotes.

SELECT article.* FROM article WHERE (((article.articleName) Like "'*"
&
Me!Combobox.Value & "*'")) ORDER BY article.articleName;

Not you had LIKE " * " & Me!Combobox & " * "
I have LIKE " ' * " & Me!Combobox & " * ' "

Also you should use Me.ComboxBox.Value
On Mar 27, 11:23 am, "Pascal Hagedorn" <[e-mail]>
wrote:

Hello Alltogether, following problem is bugging me :)

I am havin a Combobox where i can browse and select my articles. So far so
good!

Over the time my table "article" growed and now it is not very conveniant to
search for articles, the name you dont know exactly

Now i would like to realise the same Combobox with a Select statement over
the same table "article" as follows:
SELECT article.* FROM article WHERE (((article.articleName) Like "*" &
Me!Combobox & "*")) ORDER BY article.articleName;

As you can see, this sql statement looks for the entered string in the
column articleName and if it is part of any article. (if i enter "er" it
will show up "hamster" as well as "ernie" and "bertie") :)

Trying to actualize the table "after actualisation" with Me!Combobox.requery
is not working :/

I am turning myself round and round! But maybe one of you could stop ;) ....
thank and if you need further information about my problem, please let me
know!