Insert into table

Posted on 2013-10-31
Last Modified: 2013-11-01


I would like to concatenate the first name, last name and DOB and insert the concatenation in Unique_ID field in Cust_tbl

what is the easiest way to do this if I am using a form to update the table.
Question by:Eddy2010
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 70

Expert Comment

ID: 39615790
add the following to the AfterUpdate event on the First_name, Last_name and DOB text boxes on the form:

me.UniqueID = me.First_Name & me.Last_name+ & me.DOB
LVL 70

Accepted Solution

KCTS earned 500 total points
ID: 39615792
opps a + crept in...

me.UniqueID = me.First_Name & me.Last_name & me.DOB
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39615800
place this codes in your form module

Option Compare Database
Option Explicit

Private Sub First_Name_AfterUpdate()
End Sub
Private Sub Last_Name_AfterUpdate()
End Sub
Private Sub DOB_AfterUpdate()
End Sub

Sub UpdateUniqueID()
Me.Unique_ID = Me.First_Name & Me.Last_Name & Me.DOB
End Sub
LVL 61

Expert Comment

ID: 39615827
In general you should use an auto number rather than personal info for a field like this.

The concatenated string can be derived at any time for display on forms or reports without needing to be stored as another field in your table.

Also, an autonumber is meaningless to the end user.  It can be used behind the scenes as a linking ID when creating relationships in your data, but you won't run across issues that more personal ID might cause when people get married, divorced or otherwise change meaningful personal data.
LVL 61

Expert Comment

ID: 39616255
As a somewhat related aside, a continuing issue that Experts-Exchange has is that members cannot change their usernames, which is possible on other sites.  The reason for this is that the original developers used the username as a primary key rather than using a generic, meaningless ID such as an autonumber.  The fact that you can't change usernames is clearly worded in the membership agreement that everyone diligently reads when joining ...  :-) ..., but it still occasionally comes up as a problem when users decide that they really shouldn't have used their full name or other sensitive info  as their username.

Featured Post

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Suggested Courses

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question