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
|
|||
|
|||
Understanding a combo box filling another table's field
I created a combo box on a ZIP Code table within a
Contact Information form. I used the wizard to set it up so that when I select a ZIP Code from the combo box (which displays ZIP Code, City, State from the ZIP Code table), the combo box stores the ZIP code in the Contact Information field. I've looked for code to see how this happens, but can find none nor is there anything in the Property box that would make this happen. Can anyone explain the mechanism here? Thanks. |
#2
|
|||
|
|||
Understanding a combo box filling another table's field
Are you saying you used a "lookup" data type in your table? This may cause
you headaches later on, especially if your ZIPCode table uses a primary key, and your Contact table is storing the key, but displaying the ZIPCode. Rather than working directly in the table, consider using a form to display information. Build a combo box on the form that uses the ZIPCode table as a row source, and is bound to the Contact table ZIPCode field. You would need to change the "lookup" datatype to an appropriate different type. -- Good luck Jeff Boyce Access MVP |
#3
|
|||
|
|||
Understanding a combo box filling another table's field
Hi Jeff,
Thanks for your reply. Your suggestion is a good one. For the moment, though, I'm just trying to understand the mechanism of how a combo box stores field data from one table in the forms active table. George -----Original Message----- Are you saying you used a "lookup" data type in your table? This may cause you headaches later on, especially if your ZIPCode table uses a primary key, and your Contact table is storing the key, but displaying the ZIPCode. Rather than working directly in the table, consider using a form to display information. Build a combo box on the form that uses the ZIPCode table as a row source, and is bound to the Contact table ZIPCode field. You would need to change the "lookup" datatype to an appropriate different type. -- Good luck Jeff Boyce Access MVP . |
#4
|
|||
|
|||
Understanding a combo box filling another table's field
BTW, Jeff, I didn't use a Lookup data type. The form is
Contact Information (using the Contact Information table) and the combo box on the form uses the ZIP Codes table. G. -----Original Message----- Are you saying you used a "lookup" data type in your table? This may cause you headaches later on, especially if your ZIPCode table uses a primary key, and your Contact table is storing the key, but displaying the ZIPCode. Rather than working directly in the table, consider using a form to display information. Build a combo box on the form that uses the ZIPCode table as a row source, and is bound to the Contact table ZIPCode field. You would need to change the "lookup" datatype to an appropriate different type. -- Good luck Jeff Boyce Access MVP . |
#5
|
|||
|
|||
Understanding a combo box filling another table's field
I'm confused. You posted in a tablesdbdesign newsgroup. You mentioned
creating a combo box in a table. You mentioned using the wizard. These suggest that you've selected the "lookup" data type for this field, and told Access to use a combo box based on your ZIPCode table. What form? You hadn't mentioned a form before. Jeff Boyce Access MVP wrote in message ... BTW, Jeff, I didn't use a Lookup data type. The form is Contact Information (using the Contact Information table) and the combo box on the form uses the ZIP Codes table. G. -----Original Message----- Are you saying you used a "lookup" data type in your table? This may cause you headaches later on, especially if your ZIPCode table uses a primary key, and your Contact table is storing the key, but displaying the ZIPCode. Rather than working directly in the table, consider using a form to display information. Build a combo box on the form that uses the ZIPCode table as a row source, and is bound to the Contact table ZIPCode field. You would need to change the "lookup" datatype to an appropriate different type. -- Good luck Jeff Boyce Access MVP . |
#6
|
|||
|
|||
Understanding a combo box filling another table's field
Ahhh. The bound column in the Property box handles the
storage, right? And (at least in Access 2002) there's no way to bind more than one column in a table. That's why we add an Event Procedure, no? Which is a whole other question! -----Original Message----- I created a combo box on a ZIP Code table within a Contact Information form. I used the wizard to set it up so that when I select a ZIP Code from the combo box (which displays ZIP Code, City, State from the ZIP Code table), the combo box stores the ZIP code in the Contact Information field. I've looked for code to see how this happens, but can find none nor is there anything in the Property box that would make this happen. Can anyone explain the mechanism here? Thanks. . |
Thread Tools | |
Display Modes | |
|
|