dandavis1
Posts: 18
|
| Posted: 07/26/2007, 6:22 AM |
|
Hi, please let me know how to solve this problem: I would like the value of the following label (lblPerDiemRateFull) to "get" the value from tblEmployees and then keep it there for good. So I put the following code in the "after insert" event of the form but it's not working. I had the following code in the "before show" event of my form, but then it would change retroactively. Please help.
tbltimesheets.lblPerDiemRateFull.Value = CCDLookUp("perdiemrate1", "tblEmployees", "emp_name=" &_
DBConnection1.ToSQL(tblTimesheets.lstemployee.Value, ccstext), DBConnection1)
|
 |
 |
dandavis1
Posts: 18
|
| Posted: 07/26/2007, 12:53 PM |
|
P.S. I've got two tables: tblTimesheets and tblEmployees. I want to retrieve the value perdiemrate1 from tblEmployees and put it in a bound label called lblPerDiemRateFull on the tblTimesheets "record" portion of the "grid & record" page. The lblPerDiemRateFull has a control source of "PerDiemRateFull". I can use the "before show" event, but then, if I change the value of perdiemrate1 in tblEmployees, it will change the value of lblPerDiemRateFull for ALL existing old time sheets. I want a time sheet to keep the value of perdiemrate from the day it was made, and never change it. Please help. Thanks.
|
|
|
|
|
