By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,693 Members | 1,822 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,693 IT Pros & Developers. It's quick & easy.

Can't choose a combo box value

P: 7
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?
Feb 20 '08 #1
Share this Question
Share on Google+
4 Replies


jaxjagfan
Expert 100+
P: 254
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.
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.
Feb 20 '08 #2

P: 7
Your problem can have various causes - here are a few.
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.
Feb 20 '08 #3

P: 7
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?
Feb 20 '08 #4

jaxjagfan
Expert 100+
P: 254
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.
Feb 20 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.