She is right on the money. Just incase you don't know how to do that.
Open your form in design Go to menus at the top of the screen and click the menu Variables Then in that menu click add/edit variables That will open a screen put the name of the var in the box that says name vRowID In the expression box type RowID In the box that says table name pick rentroll In the box that says type pick your data type probably integer Click APPLY and then OK Remove you first line in your custom eep P Please consider the environment before printing this e-mail ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, August 03, 2009 5:58 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Change Date/Time Picker to last keyed entry Ed: The reason your eep doesn't work is the first row -- your "set var" line gets the value of the first row in RentRoll, not the row you are on. If you set up a form variable vRowID = RowID then that's all you need for your "update" command to work properly. If you do that then you don't have to mess about with componentIDs. Karen Here's the custom eep code set var vrowid = rowid in rentroll update rentroll set bankdate = .bankp where rowid = .vrowid recalc var return
