Navigating records on main form when it's sub form has multiple line items.

[akjim62]

I have a form with a sub form, and if the sub form has multiple line items, I have to click the next record or previous record buttons as many times as there are line items in the sub form, in order to move to the previous or next master record (Quote ID).

In the enclosed screen shot, I have to click the previous or next buttons 3 times to get to a different master record (Quote ID).

Any help would be appreciated so I can navigate master records one click at a time.

Thanks, Jim

 

[CJ_London]

sounds like your main form recordsource is not just for the quote header table, but the line item table as well

 

[akjim62]

That is correct, the main form and sub form are linked by QUOTE_ID, so I guess no way around the behavior...

 

[CJ_London]

rule I one table, one form

your main form just needs the quote header table

your subform just needs the quote line table

You do have two tables?