combine two fields in access form and store result in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access table with fname and lname and have a form with fullname.
I want to have user enter judt fname and lname and calculate fullname and
store that value into the field fullname in the acess table.
I am not getting this setup correctlty..
please help
Thanks
John
 
John, take a look at:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains when and how to store calculated results.

In your case, if the FullNme field should *always* be equal to first and
last name, you must not store the field. On the other hand, if it should
sometimes be different (e.g. the family name should appear before the
personal name for some people such as some Asian communities) you can use
the AfterUpdate event of the 2 text boxes as explained in the article.
 
Back
Top