 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Lookup Fields and Combo Box
Help would be much appreciated! I'm trying to add a combo box to a form that uses a tables lookup field to search for a record. It works fine, however the combo box displays the numeric id of the lookup field instead of text. How can I get the combo box to display the same column the table displays? Lookup field data types in tables lead to considerable confusion ... as you've found! You might want to consider changing that table data field type to whatever the underlying ID field is, and NOT relying on the table for your view of the data. That way, you can build your combobox control against the original (lookup) table (NOTE -- this is NOT a lookup field, but a lookup table) and set the properties for bound column as needed. Good luck! Regards Jeff Boyce Microsoft Office/Access MVP > Help would be much appreciated! > [quoted text clipped - 3 lines] > box > to display the same column the table displays? Thanks Jeff, I think I tried what you suggested with no luck. Here's a little more detail on what I'm trying to do. I have a form (frm_SearchOriginator) that has a record source of tbl_FSR that contains the lookup field "OriginatorName". I created a combo box to search on this lookup field in the table and it works just fine except the combo box only displays the primary key autonumber instead of column 1 which is the Originator Name? When I open the table is displays the Originators Name but won't show it in the combo box? Thank you for helping! I'm so frustrated and I can't believe this is so difficult to figure out. > Lookup field data types in tables lead to considerable confusion ... as > you've found! [quoted text clipped - 21 lines] > > box > > to display the same column the table displays? As I mentioned previously, don't use the lookup field as the source for your combobox. Use the underlying lookup table. Regards Jeff Boyce Microsoft Office/Access MVP > Thanks Jeff, > [quoted text clipped - 42 lines] >> > box >> > to display the same column the table displays? Did that and the combo box displays the fields I want but isn't retrieving the records from the table. Seems as though I'm missing a link. I have the record source for the form set to the table I want to update and the combo box control set to the lookup table. How do I make the connection between the two now? Thanks > As I mentioned previously, don't use the lookup field as the source for your > combobox. Use the underlying lookup table. [quoted text clipped - 50 lines] > >> > box > >> > to display the same column the table displays? The combobox is based on the underlying lookup table. The combobox is also "bound" to the field in your first table that will hold the ID value. Regards Jeff Boyce Microsoft Office/Access MVP > Did that and the combo box displays the fields I want but isn't retrieving > the records from the table. Seems as though I'm missing a link. I have [quoted text clipped - 68 lines] >> >> > box >> >> > to display the same column the table displays? Ok the rowsource for the combo box is the lookup table and the control source for the combo box is the lookup field in the source table. All that does for me is when I choose a field from the combo list it simply changes the lookup field in the source table to match? It's still not returning the records that match the field in the combo box. Source Table is tbl_FSR with the lookup field "OriginatorName", Lookup Table is tbl_Originator. Do you have any examples of this you can show me? > The combobox is based on the underlying lookup table. > [quoted text clipped - 78 lines] > >> >> > box > >> >> > to display the same column the table displays? I'm not sure how to say it differently. STOP using the lookup field in your table! Convert it to the datatype of the underlying ID. Then do as you've described, making the rowsource the lookup table (or better still, a query based on that table), and the control source the field (a "foreign key" field, NOT a lookup field). The confusion you are experiencing is due to the use of the lookup datatype field. Regards Jeff Boyce Microsoft Office/Access MVP > Ok the rowsource for the combo box is the lookup table and the control > source [quoted text clipped - 107 lines] >> >> >> > box >> >> >> > to display the same column the table displays? I got it Jeff thanks. > I'm not sure how to say it differently. STOP using the lookup field in your > table! Convert it to the datatype of the underlying ID. [quoted text clipped - 120 lines] > >> >> >> > box > >> >> >> > to display the same column the table displays? I finally figured it out! Thanks for trying to work through this with me. > Help would be much appreciated! > > I'm trying to add a combo box to a form that uses a tables lookup field to > search for a record. It works fine, however the combo box displays the > numeric id of the lookup field instead of text. How can I get the combo box > to display the same column the table displays? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.