One way......
Setting the destination of the query to a worksheet and reading the contents
of this.
Not sure I know what you mean by 'Equivalent Member' but assume you mean
that the query returns values that you want to use test against a control
value. Need to understand exactly what you are trying to do, but you can
certainly make controls visible or not based on the results of the test.
Typically with
If value1 = value2 then CommandButton1.Visible=True
where value1 might be your test value and value2 a cell value from the
destination range
for example.
Cheers
Nigel
"Jeff Q" wrote in message
...
I'm looking to display a form that shows the results of a query in a list
box.
The trick is that I'd like command buttons to be made visible dependant
upon
whether there is an equivalent member of the list, something on the lines
of
(pseduo-code)
instead of CommandButton1, CommandButton2 etc
CommandButton(counter).visible = True
Is this possible?
Jeff
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---