How to create a form that displays information in a field when the combo box changes?

Question

Database

Hello. Please help with organizing the form.
Placed the "Combobox" element on the form, the elements of which are taken from Table1 (Column A). In Table1 there are also columns B, C, D. It is necessary that when an element is selected from the "Combobox" on the elements of Field1, 2, 3, columns B, C, D are displayed.
I do not understand how to connect "Combobox" and "Field" so that when the first is updated, the value of the second is also updated.

Answer 1

Good. I will not give a fish, I will give a fishing rod.
Updating one is an event. Alter Update
Respectively, in this event it is necessary to write data assignment/updating for the second element.
Can you get data by select? Here also assign this record set to a text field.