Livecycle Designer form connected to database - button to advance to next record does not work

Mike22Doyle 10-06-2015

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.


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="" timeStamp="2015-06-10T19:23:30Z" uuid="0d801ee9-3585-459d-bc3f-

<template xmlns="">

Here is the connection

<sourceSet xmlns="">
   <source name="DataConnection" db="ado">
      <connect delayedOpen="0" timeout="15">
         <connectString>Provider=MSDASQL.1;Persist Security Info=False;Data Source=N4;Mode=Read</connectString>
      <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&#xD;
FROM N4&#xD;
ORDER BY N4.RentalUnitAddress;&#xD;
            <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">




            <font typeface="Myriad Pro"/>





               <para vAlign="middle" hAlign="center"/>


            <border hand="right">

               <edge stroke="raised"/>


                  <color value="212,208,200"/>



            <bind match="none"/>

            <event activity="click" name="event__click">



            <event activity="click" name="event__click">

               <script contentType="application/x-javascript">





Accepted Solutions (0)

Answers (0)