Hi,
I've started working with LiveCycle Designer ES 8.2 and I'm trying to make a simple connection to an Access database and step through the records.
I created the database with an ID primary key, First Name, Last Name and Description fields. And then I filled in 4 entries of names and descriptions.
I set up the ODBC data source to point to that database under Administrative Tools.
In LCD, I set up the data connection, selected the only table, tested the connection and finished. Then dragged the dataconnection items onto the page to create the objects.
Then I dropped a button on the page, called it next and added the following to the click event:
xfa.sourceSet.DataConnection.next();
So when I preview the page, the boxes show the first entry in the database just fine. But when I click on the button, nothing ever changes in the boxes and still continues to show just the first record.
Is there something I need to set in LCD or the Access database to get this call to step through the database records?
Thanks,
Robert
[url]http://forms.stefcameron.com/2006/09/18/connecting-a-form-to-a-database/[/url]
radzmar
• LoveCycle Blog
Documents you need:
• LiveCycle Designer ES2 Docs