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 questio...

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 easier.Ken

Yes, this is what I am looking for.Where can I find the syntax (or an example) for this?

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 th...

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 ...

Yes!this.boundItem(xfa.event.newText) works here!Many thanks

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 item...

Thanks allfrom the example I could see what I was doing wrongI found that you need to set the DD.rawValue = to the hidden value that you want, not the Display value (assuming that the 2 are different)

Sorry - should have been more explicitWould like to set these values using JS and if possible, by using either the text value or the hidden value..

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 l...