Going back to the original request:

>> I'd like to update a field value by allowing the user to click a button

that has a value as it's caption.

Would result with:

UPDATE bidboard SET amount = val(oButton.Caption)

-----Original Message-----

From: Vince Teachout

Sent: Thursday, March 26, 2009 4:30 PM

Fred Taylor wrote:

> On Thu, Mar 26, 2009 at 12:29 PM, Vince Teachout <teachv@taconic.net>

wrote:

>

>>

>> So why not pass "this"? You can then reference the button.Caption

>> (or any other property) directly and not need any CASE statement.

In this example, how does it eliminate the need for CASE?

Again, assuming I am understanding the problem correctly (ie, "change a

value, depending on which button I pressed."), what's the difference

between:

CASE myParam = "button1"

and

CASE oMyParam.Name = "button1"

?