A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Forms Update Field



 
 
Thread Tools Display Modes
  #1  
Old July 20th, 2004, 07:04 PM
Dsully
external usenet poster
 
Posts: n/a
Default Forms Update Field

I have First Name and Last Name fields in my tables and
form. I want to have a field that joins these 2 fields to
give me the Full Name of the person. In the form I have
the Full Name field set to:
=[LastName] & ", " & [FirstName]
Which gives me the required information to view as I go
from one record to the next but the field in the table
remains blank. I want the Full Name field in the table to
update as a user fills in the information in the First
Name and Last Name in the form.
Any ideas as to how I may able to do this?
  #2  
Old July 20th, 2004, 07:23 PM
Jim Allensworth
external usenet poster
 
Posts: n/a
Default Forms Update Field

On Tue, 20 Jul 2004 11:04:37 -0700, "Dsully"
wrote:

I have First Name and Last Name fields in my tables and
form. I want to have a field that joins these 2 fields to
give me the Full Name of the person. In the form I have
the Full Name field set to:
=[LastName] & ", " & [FirstName]
Which gives me the required information to view as I go
from one record to the next but the field in the table
remains blank. I want the Full Name field in the table to
update as a user fills in the information in the First
Name and Last Name in the form.
Any ideas as to how I may able to do this?


Don't do it.

Why? Because in a relational database, information should only be
stored once. You can always put them back together when you need to
with a query - or expression.

- Jim
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to Update Field Stupid Question Using Forms 1 July 9th, 2004 03:38 AM
NUMBERING the pages Bob New Users 7 June 14th, 2004 12:20 AM
Forms text field position lock Tara General Discussion 1 May 26th, 2004 08:01 PM
HELP: Update 1 table with calculated fields from another table Samora Running & Setting Up Queries 0 May 23rd, 2004 05:16 PM
Why doesn't this update work? Brian New Users 2 May 6th, 2004 09:33 PM


All times are GMT +1. The time now is 06:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.