Is this possible?

  • Thread starter Thread starter Jeff Q
  • Start date Start date
J

Jeff Q

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
 
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
 
Back
Top