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
|
|||
|
|||
Automatic field filling
How do I set up a form that automatically fills certain fields once one piece
of related information is inputted? An example would be from a table with an ID number and first name and last name fields, I want to fill a form for another table and expect to just type in the id number and get the computer to automatically fill in the other fields |
#2
|
|||
|
|||
Brian
The general principle, in the example you gave, is that the second table should not have first name and last name fields in it at all. Apologies if you already understand this, but it is not clear from your post what you intend. When you enter the second table's ID number via the form, you have identified the individual, and know the first name and last name by reference to the first table, so it is redundant to store this again in the second table. However, the requirement to have the first name and last name displayed on the second form is something that often arises. There are a number of approaches to this, one of which is to make your second form based on a query which includes both tables, joined on the ID field. That means you can include the first name and last name fields form the first table directly into the query, and hence onto the second form. When the ID is entered on the form, the names will automatically be shown. In this case, it would probably be appropriate to set the Enabled property of the first name and last name controls on the form to No, and their Locked prooerty to Yes, as this is probably not the place to allow editing of the name data. -- Steve Schapel, Microsoft Access MVP Brian Monk wrote: How do I set up a form that automatically fills certain fields once one piece of related information is inputted? An example would be from a table with an ID number and first name and last name fields, I want to fill a form for another table and expect to just type in the id number and get the computer to automatically fill in the other fields |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
copying value from subform field to main form field | VNoelDavis | Using Forms | 0 | January 1st, 2005 09:45 PM |
Automatic Preceeding Zeros in a field e.g. 00001234 | DD | Database Design | 2 | June 19th, 2004 05:55 AM |
Automatic field tab | jube | Using Forms | 1 | June 14th, 2004 08:33 PM |