Geo,
Could you please expound on your comment "And since you might be populating the drop down boxes with JavaScript, I would use Acrobat forms and not LiveCycle Designer."?
I've created a library of forms using LiveCycle Designer. They are basic in nature with Submit buttons and Print buttons. Some of the forms I have a DataConnection to an Access 2003 database.
The database table tblAgentsPDF has AGENTNO (text field), NAME (text field), ADDRESS1, ADDRESS2, and ADDRESS3 bound to my form.
My form has a datadropdown box named SelectField that lists the contents of my tblAgentsPDF. I can drop down the box and select an Agent Name.
I have textfields I want to populate AgentNo, Name, Address1, Address2 and Address3 with the current value of the agent in the SelectField.
I've been following the code from the purchase.pdf document but the javascript sourceSet is written for the ID field, which is numeric and mine field AGENTNO is text. I can't seem to get the form to obtain the focus of the SelectField and display the correct record. I see the first record of the table.
Any thoughts?
Thanks in advance.
Pam