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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |