How to make data from a table populate in a form

[Angela S]

Example:

Table 1= Vacation Hours Balance
Table 2= Form data

When the user clicks on their name in the combo box on the form, i need the
data from table 1 to automatically populate on the form in the appropriate
text boxes.

Please help!