Auto populate a field from two field within the same form.

[hector.roman]

Greatings, I'm utilizing Access 2007.

I have three fields in my form; Full_Name, Last_Name, First_Name. I want to auto populate the Full_Name field when I manually fill in the Last_Name and First_Name fields.

Example when I fill in Last_Name and First_Name fields with Smith and John I want the Full_Name field to auto populate with Smith, John.

I am a novice in Access and have no experience in MACRO.

 

[missinglinq]

Since Full_Name is a Calculated Field, you don't want to store this, only display it, so the Full_Name Textbox would be Unbound. In Form Design View, select Full_Name then go to Properties - Data and in the Control Source Property paste this line in:

=Nz(([Last_Name] + ", " + [First_Name]),"")

Linq ;0)>

 

[hector.roman]

Thank you for the quick response.

Actually, I want to store Full_Name so I can display it in various reports. Additionally, I want to use it to fiind some records in a form. How can I create this action so that it stores.