The code you use to open the form filters the records which the recordsource to the form shows. So you first need to make a query, or directly in the record source which resulst in ALL GRP being shown. So if you open th eform directly it is NOT filtered. Then when you open th eform using the code it will be filtered by GRP (link)
But there is a BIG difference! * means ALL fields, which mean ALL fields must be distinct. Now that you specify only the fields you want you have removed ID :o)
>> terry ja der er stor forskel, men jeg skulle ikke have distinct på alle felterne, kun på descrip, og id felter skal jeg slet ikke bruge, da det kun er en visning. jeg skal ikke updatere noget..
Question to 24-06-2004 08:37:03: How do I write my SQL to make only one field DESTINCT, and still have several other fields listed in the QUERY result, as shortly mentioned by Terry?
As soon as you choose a field in the result set which has more than one value then you will see duplicate records. So the only way around this is to only select fields which you know will result in DISTINCT values.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
