V
Vina
I have a query that is looking at a text field in a form
but what i need to do is that a user can enter a text in
that field and must list all the records that has that
text, the field i got is a long string and i need text
taht contains the text that was entered in the form.
I have tried using IIF (field not null then field
else "") but this doesnt work or i ma not doing it right.
I have use "Like " txt field but not sure i can do that I
tried using "Like " & form.field but i need to put it in
quotes but it gives me an error.
Can someone give me an idea on how i can do this?
Thanks
Vina
but what i need to do is that a user can enter a text in
that field and must list all the records that has that
text, the field i got is a long string and i need text
taht contains the text that was entered in the form.
I have tried using IIF (field not null then field
else "") but this doesnt work or i ma not doing it right.
I have use "Like " txt field but not sure i can do that I
tried using "Like " & form.field but i need to put it in
quotes but it gives me an error.
Can someone give me an idea on how i can do this?
Thanks
Vina