bigtoe
Posts: 115
|
| Posted: 06/30/2004, 5:06 AM |
|
I have text field.
The label is "Item Color".
The user can type in any color. Like, "Red" or "Green" ...
I would like the default text in this field to be "unknown".
But this default text resides in a database table
because the user wants this to be configurable. So
he can change it to "not known" or "unspecified" ...
How do I get this database table value to show up in
this text field as the initial default?
|
 |
 |
DonB
|
| Posted: 06/30/2004, 5:24 AM |
|
You will need to use the CCDLookup in the Textbox Before Show event (either
write your own code or use the "Action" callled "DLookup). Lookup the
default value (which will have to be some predefined value, maybe "0" makes
sense. Then the Textbox will have the text resulting from that lookup.
Just be sure to check if there is a value in the Textbox first, so you don't
overwrite it.
--
DonB
logging at http://www.gotodon.com/ccbth, and blogging at
http://ccbth.gotodon.net
"bigtoe" <bigtoe@forum.codecharge> wrote in message
news:540e2acb92d8cd@news.codecharge.com...
>
> I have text field.
> The label is "Item Color".
> The user can type in any color. Like, "Red" or "Green" ...
>
> I would like the default text in this field to be "unknown".
>
> But this default text resides in a database table
> because the user wants this to be configurable. So
> he can change it to "not known" or "unspecified" ...
>
> How do I get this database table value to show up in
> this text field as the initial default?
>
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
