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
|
|||
|
|||
Feild Links
I need to link two fields so that when I enter the name in the name field the
next field automatically enters his title SVP. I have already created the additional table with the names of the group and their title and I can access all the names from a drop down box but how do I get the next field to automatically add the title information in the next field? |
#2
|
|||
|
|||
You can use a DLookup in your combos AfterUpdate event:
Me.YourTitleTextBox = DLookup("strTitle", "tblTitles", "SomeField='" & Me.YourCombo.Column(1) & "'" Of course you'll have to change the table/field/control names to match your own ... this assumes that you're looking up a Text field, hence the single quote surrounding your Combo value ... if you need to lookup a Numeric value, do away with the single quotes. Note also that columns in a combo are zero based, therefore .Column(0) is the first column, .Column(1) is second, etc etc "SAA19" wrote in message ... I need to link two fields so that when I enter the name in the name field the next field automatically enters his title SVP. I have already created the additional table with the names of the group and their title and I can access all the names from a drop down box but how do I get the next field to automatically add the title information in the next field? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Removing a group of hypertext links or all hypertext links in a document | Terri Creagh | Formatting Long Documents | 5 | November 9th, 2004 05:30 AM |
Removing a group of hypertext links or all hypertext links in a document | Terri Creagh | General Discussion | 5 | November 9th, 2004 05:30 AM |
Removing a group of hypertext links or all hypertext links in a document | Terri Creagh | Tables | 5 | November 9th, 2004 05:30 AM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |
Links | Paul W Smith | Links and Linking | 3 | October 16th, 2003 02:28 PM |