I have a drop down that is pre-populated from Access.The drop down uses
both values and text description.ie: 1, Level 1; 2, level 2; 3, Level 3
etcIn another section of the form, I need to retrieve the text
description of a specific value of a drop down based on a different
field value.So my question is:If I have the drop down populated already,
how do I retrieve the text value of item X from a button?Note: The drop
down may be set at 1 (Level 1), I need to retrieve the description of 5
I have been trying to build one.But if I do not know the exact syntax
options, it becomes difficult 🙂If I knew where to look for the
documentation for this code, then the building of a sample becomes much
Unless I am missing something, your link provides a sample on how to use
a select queryie: SELECT id as catId, name AS catName FROM
movie_categories GROUP BY name ORDER BY name;I have the SELECT query
working using the WHERE clause to get a spcific record. Works great.I
use this to pre-populate the form. Once I have the forms edited via data
input from the users, they send the forms back to an administrator who
has the ODBC connection and this admin person will update the database.
I would prefe...
I have seen examples (and have them working) of the select * queries
with Access to prepopulate a form.My question is is it possible to use a
data connection with an update or INSERT INTO queryI have seen an
example on PDF Scripting with hidden fields and connecting to the
Database, then update the hidden fields to update the databaseI see how
this would work, but means I need to have 2x the data fields in my form.
To get away from this, I was hoping to have another option.What I would
like to d...
I have a drop down list as follows:Text, valueJan, 1Feb, 2....Dec,
12Select Mth, 0 (Default)I wish to use the change event and get the new
value.this.xfa.event.newText = the new selected TEXT
itemthis.xfa.event.prevText = previous selected TEXT itemthis.rawValue =
VALUE of the previous selected itemQuestion: How do I get the VALUE of
the new selected item?
Question on drop downs:How does one PRE set a drop down list value with
a set choice. (ie: not changing the raw data behind the drop down but
choosing one value to initially display - eg: select the current yr
within a group of years)Interested in knowing how to set using specific
text within the list specific value of the text selected