PLease HELP ???????

[oceanman]

Dear All

I have a small problem in Access :

I have a table named " Table1" which has the following details :

ID Name
---------------------------
1 Lewis Alex & Co
2 Lewis & Co
3 Field & Lewis Co
4 Morgan & Co
-----------------------------------

Also I Have a Query named "Query1" which is as follows

SELECT Table1.ID, Table1.Name
FROM Table1
WHERE (((Table1.Name)=[Forms]![Form1]![txtname] & "*"));

------------------------------------------------

Also I have a form named " Form1" in which i have a text box named "txtname" and a command button "cmdOK"

I have opend the Query1 on click event of cmdOK. Everything runs fine but no data is displayed if i enter "Lewis" in the textbox and press OK.

PLeaseeeeeeeee. Can someone help me and tell me what is wrong.

Thanks in Advance.

 

[Norie]

See my response in your other post.