Windows 10 
Access 2007
I have a very simple question for someone familiar with Access. I am running Microsoft Access 2007 in Windows 10. I have a form based on a table I created . Lets call that Table 1. I have a field on the Table 1 Form that I want to use to display a specific textual entry from a list that is contained in another table. Lets call that table 2. I tried using a combo box to display the Table 2 textual list entry on the Table 1 Form. When I open the combo box I want select a specific entry from the Table 2 list.
The Table 2 list is comprised of two columns. One column in the list contains an ID number for each specific Table 2 list item. Column 2 of the Table 2 list contains a textual descriptions of each of the specific Table 2 list items. Table 1 has a field for the Table 2 list ID. I want to display the Table 2 list when I click on the combo box, then select a specific list entry from the Table 2 list. I then want Access to place the specific Table 2 list entry ID in the list entry ID field in Table 1 and display the text for that Table 2 entry in a text box on the Table 1 form.
The problem I am having is that when I attempt to create the combo box on the Table 1 form and attempt to tell it to place the list entry ID in the list entry ID field for that record in Table 1, I wind up with the list ID number in the list ID field for the particular record in Table 1 (which is what I want), but I also wind up with the the list ID number displayed in the text box on the form where I created the combo box.
What I want is the list entry ID to be placed in the appropriate field in Table 1 and the text for the specific entry on the Table 1 form for that particular record.
Can you please tell me what I am doing wrong?
Reply With Quote
