2 Access Continuous Subforms on Filtered Main form Sync

[Mac1206]

My question is in using the built in filter, I have two continuous forms side by side pulling from One Table due to it having so many fields which Detail Dept. needed. Everything works accordingly with the filter except moving to the next record within the forms. Is there a way I can keep the records sync in both forms while scrolling through or tabbing through the records. Sometimes there may be as many as 300+ records and I need for both subforms to stay together when tabbing down or scrolling through FrmSubDetailsI which is the main continuous subform. Any ideas on how to accomplish this?

FrmSubDetailsI
FrmSubDetailsII

 

[Mac1206]

Or highlight the current row the cursor is on based on the Unique ID for that row for both subforms since it's pulling the data in from the same table...

 

[Micron]

I cannot imagine a situation where 2 side by side subforms from the same query or table would be a good idea. If I had room across a form's width for 10 fields I'd expect that individual subforms would cut that down to 8 or 9 visible fields because of scrollbars and such. Be that as it may, you'd need the PK field from that table in each subform to have any chance of syncing. If you've managed to sync the main and 1 subform using Master/Child relationship setting in property sheet, I imagine you could link a second subform to the same master field. However to keep (e.g.) the 4th record in 2 side by side subs to be in alignment horizontally, that would take some real effort and a lot of code. I wouldn't even want to attempt it.

 

[Micron]

You might find some code written by MajP to be useful from here

Synchronised Subform Scrollbars - Is It Possible? - Microsoft: Access Forms

Hi, I have two subforms placed on a main form (popup / modal), they each allow me to see a given record so that I can compare them side-by-side, I use this to look at possible duplicate records and merge their details into one record before getting rid of the obsolete one. My question is: Is...

www.tek-tips.com