Navigate query records using backwards, forwards type buttons

[GSS]

Hi,

I am designing a form that connects to a SQL DB backend. The form is working
as expected and I am able to submit and return records. If there are many
returned records from a query the repeating section looks a little messy and
the user has to scroll endlessly to look at the records. I have tried a table
view but due to a large comment text box this also looks a little messy.

I would like to be able to navigate the returned query records one by one
with button controls for forwards and backwards navigation.

I have tried searching the web for a guide but to no avail, canj anyone help
with this please?

Thanks,

Gavin.

 

[S.Y.M. Wong-A-Ton]

If you've bound the form to the db and are filling forms out using the
InfoPath client application, you can use the technique described in the
following article:
http://www.bizsupportonline.net/infopath2003/sequential-db-table-record-navigation.htm