I agree with this. We have something similar. The name of the button should be the value you want to store. The caption should be something similar. In cmdbutton.click() put thisform.StoreThisValue(This.Name) Now you can simply copy this button and change the name and caption of the other buttons. No need to change click()
Depending on your values, you could make that the caption and pass this.caption so you do not need to modify the button names ----- Original Message ----- From: Vince Teachout To: ProFox Email List Sent: Thursday, March 26, 2009 10:25 AM Subject: Re: Update field value Jim Harvey wrote: > I'd like to update a field value by allowing the user to click a button that > has a value as it's caption. > > There will be multiple buttons each with its own distinct value. > > I can put code in the click of each button knowing it's assigned value, and > that will do the job, but would rather use a form method. > > Is there a way to have the method determine which button was clicked, and > therefore assign the new value to the field. > > The code I'm using now in the button.click is: > > SELECT bidboard > > UPDATE bidboard SET amount = 6000 > > llok = tableupdate(1,.f.,'bidboard') > > thisform.refresh If I'm following you correctly, I would create a form method MyMethod with a parameter. In the button click, I'd either call Thisform.MyMethod(1) (Where the numeric is different for each button), or better yet ThisForm.MyMethod(this.name) (allowing for exactly the same code in each button) Then in the method, use a CASE statement, and proceed from there. [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/010c01c9ae5a$37ba84b0$8600a...@w2k3s02 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
