Hello,

Is it possible to create multiple pages in a continuous form and set each page to display a number of records. This form should also have 'Next' and 'Back' buttons to navigate between the pages.

I've been tasked to create a database for document registers. In my db, I have a continuous form that displays 300+ records.  Each document has a document number, description, rev no, date, etc. The record source for this form is based off a query. My problem is every time I open the form, it takes really long for it to display all the records. Moreover, the form keeps on recalculating when I scroll up and down which is really annoying.

My query contains multiple fields that use IIF and DLookUp functions. For example,

FUNCTION (=) DESC: IIf([FUNCTION (=)]="AA" And [AREA (++)]="AA","",DLookUp("Description","TblEquals","[Code(=)] ='" & [FUNCTION (=)] & "'"))

--> which returns a 'Function Description' if the function code in Table A(i.e AA) matches the code in Table B(i.e. AA)

I did some googling and found that complex queries can decrease the speed. I have no idea how to go about changing the query to get the output that I want other than using the formula above. And the only simple solution I could think of to improve the user experience is by creating multiple pages and limiting the number of records to be displayed so that the user doesn't have to scroll up and down.