I am trying to create a form where I have a section with text boxes and a subform displaying all the data in the table, I've created the text boxes and subform and managed to display the data. However I am trying to make it so whenever I select the a record in the subform, the textboxes get changed to the currently selected record.

I have managed to make it work using a list box, however a list box cannot be edited.

I have included screenshots to better show what I am trying to do.

what I am trying to do with the subform

what I have managed to with the listbox

CodePudding user response：

It looks like you are trying to roll your own "split form" here. See "Create a split form" at https://support.microsoft.com/en-us/office/create-a-split-form-e8eb0efb-2fa6-4315-9d4b-86e79a1fbe1e

CodePudding user response：

you can use the Private Sub Form_Current() on the subform. There you update the buttons in the main form.