Storing result of query into variable in VBA

[asanchez4]

I need to execute a query in VBA and depending on the result change the color of a button. I have done this before, but have misplaced my code and can no longer figure it out. Please help.

This is how it worked in the past.

The table is 'Customers' and I have a query "Customer1" that returns the value of the field 'Name' for CustomerID=1.

I stored the results of the query into a variable and then branched according to the value of the variable.

Thanks in advance.

 

[formerTexan]

If you are using A2K or a later version, see conditional fomatting.