T
Tdungate
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
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