Don_S
Posts: 50
|
| Posted: 12/07/2005, 11:22 AM |
|
I need to use CCDLookup to populate a textbox before data is written to the database. The CCDLookup is based off of variables input into textboxes on the Record form so the lookup has to take place after the page has loaded but before the data is sent out. I tried using the onClick event on the "Add" button but that did not work. I found out by searching the Forum that you can't do it that way. Here's the lookup code I have:
tbl_Calls1.Tot_Time.Value=CCDLookup("Time_Desc","tbl_Times","Time_Int=" & tbl_Call1.Total_Time.Value , DBConnection1)
Where do I need to place it to have it work?
Thanks,
Don
|
 |
 |
wkempees
Posts: 1679
|
| Posted: 12/07/2005, 11:27 AM |
|
tbl_Calls1.Tot_Time.Value=CCDLookup("Time_Desc","tbl_Times","Time_Int=" & tbl_Call1.Total_Time.Value , DBConnection1)
There is an "s" missing within the CCDLookup, is that on purpose or the cullprit?
& tbl_Call#1.Total
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Don_S
Posts: 50
|
| Posted: 12/07/2005, 11:44 AM |
|
The "s" missing was a problem but I still need to know where the event should fire from. Thanks Walt.
Don
|
|
|
|
Don_S
Posts: 50
|
| Posted: 12/07/2005, 1:40 PM |
|
Update:
The missing "s" in my original code WAS the problem. Adding the code to the Records "Add" button onClick event worked perfectly.
Don
|
|
|
|
|
