1 IS TRUE , 2) is only true in regards to filling the listbox. when the button is clicked the listbox shows repeated data and therefore doesn't work well.
the sql on the button has no AND or OR operators. So why is it getting repeated data? The zearchall3 query works fine and that is the one with the AND and OR operators.
I have some code i run on a query it produces many multiples of the same answer.
The situation is that i have a listbox with the query 'zearchall3' and i have form controls that affect the data shown in the listbox
i then click on the button (the code for is supplied at the end of this) which...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.