Recent content by Mansel160

DLookup Hi Paul, I tried the DLookup as suggested, I get a #Name Error. I have checked and double checked the syntax and all is ok. I have a query which has 1 as the criteria and yes as the criteria in another field then do a count on the field containing the 1's this works ok. But just can't...

Many thanks Thanks for your help Paul and thanks Adam. Mansel160

Hi All, Newbie looking to learn here! I am trying to display in a textbox the results of a query, I can get the query to work but just can't get the results to display on my form. What I am doing is using 2 fields in the query. field 1 is simply Yes or No, field 2 is iether 1, 2, or 3. Using...