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.
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.