I have a liecycle designer form that is connected to a query in an MS Access 2010 database. I have placed a button on the form to advance to the next record. It doesn't appear to be doing that. The form was created using Livecycle Designer ES4. When I click on the button nothing happens. I realize it might be something as simple as a refresh, and if that's so, please give me a hint as to how to do that.
Thanks.
here is the header in the XML of the form.
<?xml version="1.0" encoding="UTF-8"?>
<?xfa generator="AdobeLiveCycleDesigner_V11.0.0.20130303.1.892433" APIVersion="3.6.13061.0"?>
<xdp:xdp xmlns:xdp="http://ns.adobe.com/xdp/" timeStamp="2015-06-10T19:23:30Z" uuid="0d801ee9-3585-459d-bc3f-
1b8d4c3435f8">
<template xmlns="http://www.xfa.org/schema/xfa-template/3.0/">
Here is the connection
<sourceSet xmlns="http://www.xfa.org/schema/xfa-source-set/2.8/">
<source name="DataConnection" db="ado">
<connect delayedOpen="0" timeout="15">
<connectString>Provider=MSDASQL.1;Persist Security Info=False;Data Source=N4;Mode=Read</connectString>
<user/>
<password/>
</connect>
<command timeout="30">
<query commandType="text">
<select>SELECT N4.TO_TenantName, N4.From_LandlordName, N4.RentalUnitAddress, N4.PayDate,
N4.OweMeAmount, N4.ArrearFrom1, N4.ArrearTo1, N4.RentCharged1, N4.RentPaid1, N4.RentOwe1, N4.ArrearFrom2,
N4.ArrearTo2, N4.RentCharged2, N4.RentPaid2, N4.RentOwe2, N4.ArrearFrom3, N4.ArrearTo3, N4.RentCharged3,
N4.RentPaid3, N4.RentOwe3, N4.RfirstName, N4.Rlastname, N4.RDayPhone, N4.AgentName, N4.AgentLSUC, N4.AgentCompany,
N4.AgentAddress, N4.AgentPhoneNum, N4.AgentMunicipality, N4.AgentProvince, N4.AgentPostCode, N4.AgentFaxNum
FROM N4
ORDER BY N4.RentalUnitAddress;
</select>
<recordSet cursorType="forwardOnly" cursorLocation="client" lockType="readOnly" bofAction="moveFirst"
eofAction="stayEOF" max="0"/>
This is the Button code
<field name="Button1" y="3.651mm" x="14.617mm" w="28.268mm" h="6.738mm" relevant="-print">
<ui>
<button/>
</ui>
<font typeface="Myriad Pro"/>
<caption>
<value>
<text>Button</text>
</value>
<para vAlign="middle" hAlign="center"/>
</caption>
<border hand="right">
<edge stroke="raised"/>
<fill>
<color value="212,208,200"/>
</fill>
</border>
<bind match="none"/>
<event activity="click" name="event__click">
<execute/>
</event>
<event activity="click" name="event__click">
<script contentType="application/x-javascript">
xfa.sourceSet.DataConnection.Next();
</script>
</event>
</field>