469,270 Members | 1,583 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

Can't choose a combo box value

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
4 4920
jaxjagfan
254 Expert 100+
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
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
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
254 Expert 100+
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.

Similar topics

3 posts views Thread by vgrssrtrs | last post: by
9 posts views Thread by art | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.