Combo Box doesn't work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box on my form it has been working but since yesterday
afternoon it doesn't.

What it is this: I can open the form. Click on the combo box and the
info drops down, I scroll the the company I want to display but when I click
on the company NOTHING happens. It won't let me click on anything.

What is going on.
The property fields for the combo box are set to the following:

RowSource=Table/Query
Bound Column=2 was 3
Limit to List=Yes
Auto Expand=Yes
Visialbe=Yes
Display When= Always
Enabled=Yes (was playing with this yesterday)
Locked=Yes (was playing with this yesterday, maybe I screwed something up)
Allow Auto Correct=Yes

Here is the Property Fields for the Form:
Allow Filters=Yes
Default View=Single Form
Allow Edits=No
Allow Deletations=No
Allow Additions=No
Data Entry=No
Recordset Type=Dynaset
Record Locks=All Records

This form is used for viewing records only. There is no updating involved.

Any ideas as to what is causing this?
 
Locked = Yes means you can view the contents, but you can make no changes to
it. This is probably causing the problem.
 
Hard to say without knowing more about the combo box. Why did you change the
bound column? Could that be the problem? Is this combo box bound to a field
in the underlying table, or is it an unbound combo box that you use to locate
a record (note that an unbound combo box indicates a bound column in the
combo box properties, and that even though you mentioned a bound column it is
not automatic that it is a bound combo box).
I would be tempted to just re-create the combo box.
 
I have a combo box on my form it has been working but since yesterday
afternoon it doesn't.

What it is this: I can open the form. Click on the combo box and the
info drops down, I scroll the the company I want to display but when I click
on the company NOTHING happens. It won't let me click on anything.

What is going on.
The property fields for the combo box are set to the following:

RowSource=Table/Query
Bound Column=2 was 3
Limit to List=Yes
Auto Expand=Yes
Visialbe=Yes
Display When= Always
Enabled=Yes (was playing with this yesterday)
Locked=Yes (was playing with this yesterday, maybe I screwed something up)
Allow Auto Correct=Yes

Here is the Property Fields for the Form:
Allow Filters=Yes
Default View=Single Form
Allow Edits=No
Allow Deletations=No
Allow Additions=No
Data Entry=No
Recordset Type=Dynaset
Record Locks=All Records

This form is used for viewing records only. There is no updating involved.

Any ideas as to what is causing this?
Click to expand...

1) Set the Combo's Locked property to No.
2) Set the Form's Allow Edits property to Yes.
You cannot change any control value if the Allow Edits property is No.
 
Ok - I've re-created the combo box. It is now Unbound. IT STILL DOESN'T
WORK!!!!!!!!!!!!!!!!!!!!!!!!!

It won't let me click on anything. WHY????? This was working all of last
week and yesterday.

What's the difference between bound & Unbound. Form should bound or
unboard. I'm new to this. Please explain.

I can't continue with all the other forms without having this working. I
don't want to re-create the form.

Again this form is for VIEWING ONLY. There is NO updateing, deleting or
editing going on. Just want to VIEW the information that is in the table on
the form.

This makes no sense: "(note that an unbound combo box indicates a bound
column in the combo box properties, and that even though you mentioned a
bound column it is not automatic that it is a bound combo box)."

Please somebody outthere help me!!!!!!
 
Thank you Both!!!!!

Now I got other problems - Disappearing data in the table itself and I need
to match the Idnumber w/what I have on the main form.
 
I did not explain very well. Data are stored in tables. Let's say you have
a table named tblCompany, which includes fields for CompanyName, Phone,
Street, City, etc. If you create a form and set its record source to
tblCompany, then controls (text boxes, combo boxes, and so forth) on that
form can be bound to fields in tblCompany. That is to say, if you add a text
box to the form and set its Control Source to CompanyName, when you create a
new record and type a company name into that text box, the information will
be stored in the CompanyName field in tblCompany. The form is bound to
tblCompany, and the control (the text box) is bound to a field in tblCompany.
An unbound control on a form may be something like a combo box that is used
to find a particular record (a particular company name, for instance), or a
text box for performing some sort of calculation, or other information that
will not be stored.
Any combo box, including an unbound one, has a bound column, which may be a
bit misleading. If you are using the combo box to find a record for a
company you are telling the database: "Find the record that has the same
data in the CompanyName field as what is in the bound column of the record I
selected in the combo box." If the combo box has just one field in its row
source then the bound column can only be the first column. If the combo box
has two columns in its row source then you need to choose the bound column,
even if that column is hidden.
 
Back
Top