ms access - Fixed Datasheet width for split view form

Question

I have a form that shows information for people that is set as a Pop Up form. I would like a list of the people on the left of the form such that when a person is selected (clicked on) in the list, their details are shown in the form. I have tried a split form which works functionally, but resizing the window does not work the way I want it to. When form window is resized (left to right) the datasheet portion resizes, not the form. I would like the width of the datasheet to be fixed, and if the window is resized, the form resizes, not the datasheet.

I have also tried to do this effectively with a subform, however I cannot get the main form and subform to sync. I have it where when a record is selected in the subform, it filters the parent form to the proper record, however, in doing do, the subform resets (a requery maybe?) and the selected person is no longer selected.

question from:https://stackoverflow.com/questions/66059319/fixed-datasheet-width-for-split-view-form

Answer 1

Waitting for answers