Concatenating

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top