Brad, set the column value in an ON AFTER START eep, assuming this is a one row form header, not a scrolling region. Then the value is there, but the user can select another with the combo box.
Brad Davidson <[EMAIL PROTECTED]> wrote:
Brad Davidson <[EMAIL PROTECTED]> wrote:
Looking for a tip here. PO form shows vendor profile billing terms (ex: Net
30) in a variable edit field (read only). Terms billing DB LookUpComboBox.
LookUp settings sort order by TID (integer) col, hard coded by most often
selected by the user.
However, I now want to display the vendor's profile billing terms by default
in the LoopUpComboBox, yet still allow user to select another billing term
via this combobox.
Other than creating a view prior to form entry, etc... I'm not sure how to
accomplish this, but I know readers of this list have some ideas which I
appreciate!
Thanks,
Brad Davidson
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB
Sent: Monday, November 22, 2004 3:14 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - RE: CHKBOX funtionality in Forms
>select statement? If I do a concatenation of two columns it returns the
>value of the concatenation but I would prefer to have the value of only
When I want this functionality from a listbox, I do something like this:
Load the Listbox with an _expression_, either from lookup or Load_From_File,
but
make the _expression_:
((ljs(TheValueToDisplayInTheListBox,30)) +',' + TheReturnValue)
Where the LJS value is wider than the listbox display, then when you get the
value selected, just do a (SSUB(WhateverTheValueIs,2)) and you will have the
return value...
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
