I have a drop down list on a web form populated by a field in the table called ID
Then I have two other fields in the same access table called Name and Occupation

What I want to to happen is that when I select a ID in the drop down box of the web form I would like the information of the other two fields to be populated into the web form using the textboxes (txtName, txtOccupation)

Well, provided autopostback="true" on the dropdown, then in the selectedindexchanged event, put code in there that retrieves the name and occupation from the database, then assign those values to the textbox.

sub ddl_selectedindexchange(..)
  'ADO.NET code to get data from database based on ID
  'with Stored Proc or sql query method
  'Get to datatable level (or can change to be a dataset)

  if (myTable.Rows.Count > 0) then
    Dim objRow As DataRow = myTable.Rows(0)
    'If you have a datarow, do this to assign to textbox:
    txtName.Text = objRow("Name").ToString()
    txtOccupation.Text = objRow("Occupation").ToString()
end sub

HTH,

Brian