I have a combo box on a form. When I click the arrow button I get a popup saying "Enter Parameter Value" in the blue title bar and below the title says Outage.ID. (Outage is the name of the table I get my values from). Below that is a spot to enter data and "OK" and "Cancel" buttons. When I click "OK" the drop down list for the combo box appears, correctly displaying the values from the table. However, when I clcik on a value it does not populate into the combo box area. I cannot even manually type in the value I want. What is going on here?
-
-
Your problem can have various causes - here are a few.Originally posted by gscott1
Make sure your combobox is bound to the correct field and that field is not an autonumber or not locked.
Make sure the data source for the form is editable - if you use grouping in a query and then use the query as the data source then you can't edit the data.
Make sure the form is open for data entry and not read-only. -
Yep it was bound to the wrong column. Thanks.Originally posted by jaxjagfanComment
-
It solved my problem of not being to choose a value the only thing left to do now is to get rid of the dialogue box that pops up. Can you help me with this?Comment
-
Look at the rowsource for the combobox. If it is a query that is used elsewhere then make a new query as the rowsource. The prompt is most likely in the criteria of the table or query you are using as a rowsource.Comment
Comment