 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Common Cause for Combo Box Not Showing Value
Is there a common reason for a combo box not showing any values? Is there something wrong with the code in the RowSource, below: cboQstPtVal SELECT tblQuestions.QstWithPtVal, tblQuestions.QstID, tblQuestions.[DM Category] FROM tblQuestions WHERE (((tblQuestions.[DM Category])=forms!testsubfrmDMInspDet!cboDMCategories)); If I add "OR 'An actual category name' " that category list will show up. cboDMCategories allows a user to pick a category and is working. I put an AfterUpdate Event in the cboDMCategories to Requery cboQstVal, but that has not helped. Thanks very much ridgerunner Hi, there is a problem with the way you are referencing the subform. Change forms!testsubfrmDMInspDet!cboDMCategories to forms!MainFormName!NameOfSubformControl!cboDmCategories Replace MainFormName and NameOfSubformControl with your names. Note that the name of the subform control may be different from the name of the form that sits inside the subform control. Jeanette Cunningham > Is there a common reason for a combo box not showing any values? > Is there something wrong with the code in the RowSource, below: [quoted text clipped - 13 lines] > Thanks very much > ridgerunner What would it look like if the subform is not yet sitting inside a main form? > Hi, > there is a problem with the way you are referencing the subform. [quoted text clipped - 26 lines] > > Thanks very much > > ridgerunner as you had it forms!testsubfrmDMInspDet!cboDMCategories A few questions. How many columns in cboDmCategories? Which column is the foreign field for the query for cboQstVal? How many columns in cboQstVal? If you drop down cboQstVal, can you see any data? Jeanette Cunningham > What would it look like if the subform is not yet sitting inside a main > form? [quoted text clipped - 32 lines] >> > Thanks very much >> > ridgerunner If I drop down cboQstVal I do not seen any data. 3 columns are in cboDMCategories 4 columns in cboQstVal I do not understand the question about the foreign field for the query for cboQstVal. The query is the same as the SELECT statement below. I would like to ask another question. The form originally used the table that the data would be entered into as the Record Source, before I tried using combo boxes. Would that be different now? Thanks for your help > as you had it > forms!testsubfrmDMInspDet!cboDMCategories [quoted text clipped - 43 lines] > >> > Thanks very much > >> > ridgerunner To answer your question about the form's recordsource - using the table is fine. About the combo boxes. Which column is the bound column for cboDMCategories? Which column has DMCategories in it? In the after update event for cboDMCategories, put this line of code Debug.Print "DMCategory: " & Me.cboDMCategories Open the form and select a category. Press Ctl + G to open the immediate window. What is the value for DMCategory in the immediate window? Jeanette Cunningham > If I drop down cboQstVal I do not seen any data. > 3 columns are in cboDMCategories [quoted text clipped - 61 lines] >> >> > Thanks very much >> >> > ridgerunner If the column numbers begin with 1, otherwise adjust for -1: The bound column for cboDMCategories is column 1 (DMCatID) Column 2 has DMCategories in it. The value for DMCategory in the immediate window is 1DMCategory:1' Thanks for your help. > To answer your question about the form's recordsource - using the table is > fine. [quoted text clipped - 76 lines] > >> >> > Thanks very much > >> >> > ridgerunner Sorry for the typo. Immediate window is 'DMCategory:1' > If the column numbers begin with 1, otherwise adjust for -1: > The bound column for cboDMCategories is column 1 (DMCatID) [quoted text clipped - 83 lines] > > >> >> > Thanks very much > > >> >> > ridgerunner The bound column of cboDMCategories is the column that must appear in the where clause of the query for cboQstPtVal. so the query for cboQstPtVal should be more like: SELECT tblQuestions.QstWithPtVal, tblQuestions.QstID, tblQuestions.[DM Category] FROM tblQuestions WHERE (((tblQuestions.[DM CatID])=forms!testsubfrmDMInspDet!cboDMCategories)); Note that I have replaced FROM tblQuestions WHERE (((tblQuestions.[DM Category])=yadda, yadda, ... with FROM tblQuestions WHERE (((tblQuestions.[DM CatID])=yadda, yadda, ... This assumes that the field called DM CatID actually has a space in its name. Jeanette Cunningham > Sorry for the typo. Immediate window is 'DMCategory:1' > [quoted text clipped - 95 lines] >> > >> >> > Thanks very much >> > >> >> > ridgerunner Thank you SO much. The drop down works now, but I am having another problem. If I close the form, reopen and change a record, all the entries for QstPtVal that have a category different from the one I am working on blank out. How can I fix that? > The bound column of cboDMCategories is the column that must appear in the > where clause of the query for cboQstPtVal. [quoted text clipped - 114 lines] > >> > >> >> > Thanks very much > >> > >> >> > ridgerunner I moved the Requery to the OnEnter Event and that seems to work better. If this might create problems or I am just not doing this incorrectly, please let me know. > Thank you SO much. The drop down works now, but I am having another problem. > If I close the form, reopen and change a record, all the entries for [quoted text clipped - 119 lines] > > >> > >> >> > Thanks very much > > >> > >> >> > ridgerunner |
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.