Solved

Default value help!

Posted on 2003-11-03
10
230 Views
Last Modified: 2013-12-18
I have 2 fields on my form abtnm & abtnmR, for both the default value is "".  Field abtnm's value (text) is chosen, by the user,  via a dialog list that uses a @DbColumn fucntion for choices.  Field abtnmR's value can also be chosen via a dialog list that uses a @DBlookup function based on the value of abtnm for choices, OR it can be left blank.  

I want the value of abtnmR to default to the value of abtnm if the field is left blank.

How can I do this?
0
Comment
Question by:rognyn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 14

Accepted Solution

by:
p_partha earned 250 total points
ID: 9672900
Ok in the abtnm field's input translation just put this:
field abtnmR:=@if (abtnmR ="";abtnm;abtnmR);abtnm

Let me know whether this is what u wanted...

Partha
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9672977
I would rather set the field value in abtnmR Input translation.

@if( @Trim(abtnmR) = ""; abtnm; abtnmR)

~Hemanth
0
 

Author Comment

by:rognyn
ID: 9673476
Actuall both worked.........I chose the first.
You guys make this look sooooooeasy!
Thanks...
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 14

Expert Comment

by:p_partha
ID: 9673577
So can we get the points :-)

Partha
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9673802
I know both will work, but you know why I suggested that path... Guess ?
0
 
LVL 14

Expert Comment

by:p_partha
ID: 9673933
Hemanth,

i am not sure why u said that, but what i thougth was if the user clicks the cursor into any other field apart from abtnmR, after choosing the abtnm field then ur logic may not work... Just a thought.. but would love to hear ur side comments

Partha
0
 
LVL 14

Expert Comment

by:p_partha
ID: 9673987
But i realized that input translation fires when the page is refreshed, so ur thing also shd work...

Partha
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9674030
Simple, whenever the problem occurs in that field like field blanks out (like you would have seen lot in this forum) and first guess is to check the current fields translation or validation...Right ! So it is most of a design standard rather than personal choice.
0
 
LVL 14

Expert Comment

by:p_partha
ID: 9681946
Is it abandoned.....


Partha
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9682228
on vacation ?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question