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
|
|||
|
|||
How do I setup a combo box in form to populate other text boxes
Hi,
I am trying to setup a data entry form for my users so they do not have to type in an address. I would like to make it so they select the name of a branch and the complete address of that branch populate to the other text boxes once selected can someone please help me? Also can I also do this with another item on the same form? |
#2
|
|||
|
|||
How do I setup a combo box in form to populate other text boxes
Use the After Update event of the combo box and the DLookup Function to
accomplish this. The names are made up, substitute the real names. If the field that identifies your branch is numberic, use this form: Me.txtBranchAddress = DLookup("[BranchAddress]", "BranchTable", _ "[BranchID] = " & Me.cboBranch) If it is text, use this form: Me.txtBranchAddress = DLookup("[BranchAddress]", "BranchTable", _ "[BranchID] = '" & Me.cboBranch & "'") "PS" wrote: Hi, I am trying to setup a data entry form for my users so they do not have to type in an address. I would like to make it so they select the name of a branch and the complete address of that branch populate to the other text boxes once selected can someone please help me? Also can I also do this with another item on the same form? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
Filling in an array of text boxes based on a query? | tjandt | Running & Setting Up Queries | 3 | August 10th, 2005 08:24 PM |
Populate text boxes with hidden combo box columns | winsa | Using Forms | 1 | April 13th, 2005 02:36 AM |
Combo Box & Text Box | AccessRookie | Using Forms | 3 | April 6th, 2005 11:33 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |