Subject Re: Like query From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Wed, 25 May 2022 18:59:22 +0530 Newsgroups dbase.getting-started Good Evening Mervyn, >> This is in case my earlier mail did not help in solving your issue. >> >> I do not have your tables hence cannot open the form. >> Copy paste and execute the following code in command window > > Did you try your code with a table containing a fieldname with a space > in it?  It may work in the command window (I haven't tried it there) but > it doesn't work in a program.   When the query opens it finds all the > records but the search return 0. :-( Few things are a strict NO for me. fieldname with spaces or reserved words fieldnames are part of them. So do not have tables to check these. Ideally I should have tested Tom's code by creating a table of my own and inputting data. But unfortunately I cannot spare that much time. So I just checked what I could easily. And then posted from my  debugging experience and added in the last line that the code was not tested. Regards Akshat