T
TK
You could try putting a text box on your form with the
control source set to "ContactName" in your table.
Then in VBA code, make a procedure for the change event
of both the first name and last name text boxes.
example--->
Private Sub txtFirstName_Change()
txtContactName = txtFirstName & "," & txtLastName
End sub
Private Sub txtLastName_Change()
txtContactName = txtFirstName & "," & txtLastName
End sub
<--------------
You can also make the txtContactName visible property set
to false so that the users are not even aware of the
changes that you have made and keep the form design the
same.
control source set to "ContactName" in your table.
Then in VBA code, make a procedure for the change event
of both the first name and last name text boxes.
example--->
Private Sub txtFirstName_Change()
txtContactName = txtFirstName & "," & txtLastName
End sub
Private Sub txtLastName_Change()
txtContactName = txtFirstName & "," & txtLastName
End sub
<--------------
You can also make the txtContactName visible property set
to false so that the users are not even aware of the
changes that you have made and keep the form design the
same.