I have a form that I use to lookup records in a database. I want to be able
to update the lookup information in the form and then write the record back
to the How do I select the first empty row in row "K". I want to use a form
to copy the following info to Row 2, Column "K".

Search by lastname, then bring lastname, firstname, etc. to the screen. If I
have to change the lastname (i.e. marriage), then write the changes to the
worksheet.


Form Lookup:
Lastname €“ Davies
Firstname - Cindy
DOB - 5/1/59

Code to lookup:
Private Sub Combobox1_Change()
TextBox50.Value = Combobox1.Column(1)
TextBox51.Value = Combobox1.Column(4)
End Sub

Code to Write needed:

Worksheet Write:
Lastname €“ Dungate
Firstname - Cindy
DOB - 5/1/59