473,408 Members | 2,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

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 5343
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

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

Similar topics

3
by: vgrssrtrs | last post by:
<html> <head> <script language="JavaScript"> <!-- /* *** Multiple dynamic combo boxes *** by Mirko Elviro, 9 Mar 2005 *** ***Please do not remove this comment
2
by: Terry Bickle | last post by:
Please forgive me for using the wrong term here or there. I'm an old Excel 4 macro guy who didn't convert to VB and I'm tinkering with an Access 2000 DB. I'm sure there is a simple Access 101...
2
by: kmnotes04 | last post by:
Is it possible to link one drop-down box to another? For example, if a name is chosen from a drop-down list, can another drop-down list then automatically display the person's office as a result of...
13
by: nyt | last post by:
I have a problem of number and text field. I got the database file(mdb) that contains many combo boxes used and its list values are created by "value list" For eg field Field name= 'furniture'...
20
by: MLH | last post by:
120 MyString = "How many copies of each letter do you need?" 150 MyVariant = InputBox(MyString, "How Many?", "3") If MyVariant = "2" Then MsgBox "MyVariant equals the string '2'" If...
5
by: MLH | last post by:
I have a vehicle entry form with a combo box for choosing the owner. Let's say the user opens the list by clicking the arrow then choose the owner by clicking a name. That much works fine. But...
9
by: art | last post by:
Hi, We have some scripts here where we use some AJAX to populate some of the page. Basically the AJAX routine calls a PHP script. That PHP script uses a bunch of ECHO statements to create...
12
by: Lnwolf | last post by:
Hello, I am having an issue with my synchronized combo boxes and don't know how to fix it. I have created two boxes and have made the synchronization work (the user clicks on the first box and...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.