Subject Re: SQL statement not working on the form From Mervyn Bick <invalid@invalid.invalid> Date Mon, 31 Aug 2020 10:36:39 +0200 Newsgroups dbase.getting-started On 2020-08-31 05:19, AGOSTINHO wrote: > Dear Mervyn Bick > I appreciate your assistance to this issue. > I'm still very confused and don't see how to put this form work. > I don't know if it to much asking if you can make this form work from the top to the bottom, so I can just copy the whole thing and paste it to the form and make it work. > > My database is a products.dbf > > I want to  add a GRID to the form that have to list the itemcode,brand,description fields > > An entryfield that will input the search criteria lets say ordered by brand name. > > Yes very interesting where you say that this can work showing the result on the GRID as you type into the entryfield. > I'm afraid I have to go out this morning so I can't do this right away. I will, however, look at the later today. Mervyn.