combine two fields in access form and store result in table

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"john z" john wrote in message
...
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