Don't allow select in combo box

[Sue-Fong]

It is an unbound combo box, it'll display the list but when moving the
cursor to the list and clicking, it won't select.
(It is blank in the Control Source property.)
Know why?

 

[Kevin Sprinkel]

The Locked property may be set to Yes. If that doesn't
solve it, please post the values of the other properties
on the Data tab.

HTH
Kevin Sprinkel

 

[GVaught]

Is your combo box based on a different table or data that resides in the
same table that the form uses?

Did you rename the combo box after setting the link to the table? If so,
this will generally break your Lookup and you have to delete the combo box
and the code it wrote and recreate.

 

[Sue-Fong]

The properties are as follows:

Row Source Type: Table/Query

Row Source: Select [client table].[client name]from [client table];

Column Count: 1

Column Heads: No

Column widths: 1.7077"

Bound Column: 1

List Rows: 8

List Width: 1.7083"

Limit To List: Yes

Auto Expand: Yes

Visible: Yes

Display When: Always

Enabled: Yes

Locked: Yes

Allow AutoCorrect: Yes

Tab Stop: Yes

Tab Index: 1

Left: 4.2"

Top: 0.16"

Width: 1.95"

Height: 0.25"

back Style: Normal

Back Color: -2147483643

.....

Blanks on all the Event properties.

Help!

 

[SF]

Yes, I did modify the Combo box's name and some properties.

I got part of the problem resolved: the main form needs to set the Allow
Edits property of Data tab to be Yes, then it'll display your selection in
the combo box.

The combo box is based on the same table that the form use. Now when I
select the value from the list, other fields in the form supposed to show
the data from the same record, but they don't. How to make connection
between the selection from the combo box and the other fields in the same
record of the same table?

 

[fredg]

Yes, I did modify the Combo box's name and some properties.

I got part of the problem resolved: the main form needs to set the Allow
Edits property of Data tab to be Yes, then it'll display your selection in
the combo box.

The combo box is based on the same table that the form use. Now when I
select the value from the list, other fields in the form supposed to show
the data from the same record, but they don't. How to make connection
between the selection from the combo box and the other fields in the same
record of the same table?

According to the property settings you listed in one of your previous
messages, your combo box's Locked property is set to Yes.
It should be No.

 

[Bruce]

You wrote that it is an unbound combo box. I will assume
this means it is supposed to be unbound. You can populate
other fields by adding fields to the query or table that
is the combo box's row source. It would have been easier
to answer had you given any indication of any details at
all about the database, but absent that I will pretend you
are selecting a customer name and you want the address,
etc. to appear in text boxes elsewhere on the form. I
will call the combo box cboCustomerName. You say your
combo box is based on a table. If your table fields are
CustomerID, CustomerName, CustomerAddress, etc. in that
order, set the combo box's Column Count to 3, and the
column widths to 0";1.5";0". Set the record source of the
address text box to =cboCustomerName.Column(2). Column
(2) is actually the third column. The first column
(CustomerID in this case) is Column(0).
Consider basing the combo box on a query that includes
only the necessary fields.
If you want to select an entire record based on a combo
box selection, use the combo box wizard to get yourself
started.

 

[Kevin Sprinkel]

Reset the Locked property to No; this is preventing data
from being entered.

Kevin Sprinkel

-----Original Message-----
The properties are as follows:

Row Source Type: Table/Query

Row Source: Select [client table].[client name]from [client table];

Column Count: 1

Column Heads: No

Column widths: 1.7077"

Bound Column: 1

List Rows: 8

List Width: 1.7083"

Limit To List: Yes

Auto Expand: Yes

Visible: Yes

Display When: Always

Enabled: Yes

Locked: Yes

Allow AutoCorrect: Yes

Tab Stop: Yes

Tab Index: 1

Left: 4.2"

Top: 0.16"

Width: 1.95"

Height: 0.25"

back Style: Normal

Back Color: -2147483643

.....

Blanks on all the Event properties.

Help!

The Locked property may be set to Yes. If that doesn't
solve it, please post the values of the other properties
on the Data tab.

HTH
Kevin Sprinkel

.