Combo Box won't let me choose the values in it

I just encountered this same issue. I went back to the Form Properties and set Data-Allow Edits to "Yes" that fixed it.

Best of luck !



jbreyare wrote:

Ok, I think i'm changing how I am going to do this.The Combobox has values in i
09-Oct-09

Ok, I think i'm changing how I am going to do this.

The Combobox has values in it from 1-40 like it should ANd I am able to
select on them. However, when I select one of the values the other text
boxes in my form do not populate with any information. Ideally, i would like
to have that information bee filled in with the corresponding row values for
the combobox selection. On top of that I would like to be able to edit that
information and then update the table's corresponding rows. One problem I am
running inot is that when I select a value in the combobox and then enter
information into the other fields, it thinks I am trying to enter another
value into the combobox. I do not want another value, I want to update that
specific record.

"Dirk Goldgar" wrote:

Previous Posts In This Thread:

On Friday, October 09, 2009 2:11 PM
Jeff Breyare wrote:

Combo Box won't let me choose the values in it
Access 2007
I have a combo box that shows all 40 selections inn it but it will not let me select any of them. Even on the bottom left corner it says "record 1 of 1" instead 1 of 40 etc...

Property Sheet
Control Source =[WeeksOut] This is my primary key adn the field I want the lookup to happen on
Row Source:
SELECT [West 09].WeeksOut, [West 09].Exhibitors, [West 09].Retail, [West 09].Cancels, [West 09].Attendees, [West 09].RegFeeRevenue, [West 09].OptionFeeRevenue FROM [West 09] ORDER BY [West 09].WeeksOut;

Source Type = Table/Query
Bound Column = 1
Limit to List = Yes
Allow Value List Edits = Yes
Enabled = Yes
Locked = No
Auto Expand = Yes

I cannot seem to figure out what I am missing here.

EggHeadCafe - Software Developer Portal of Choice
Accessing IIS Hosted WCF Services from PHP
http://www.eggheadcafe.com/tutorials...osted-wcf.aspx

On Friday, October 09, 2009 2:41 PM
Dirk Goldgar wrote:

"Jeff Breyare" wrote in message your
Is your form itself updatable? Can you change the values of other bound
controls on the form?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

On Friday, October 09, 2009 3:16 PM
jbreyare wrote:

Besides the combo box with the "WeeksOut" values I also have 7 text boxes set t
Besides the combo box with the "WeeksOut" values I also have 7 text boxes set
to return the value of each field based upon the criteria selected in the
combo box. Those are not updateable. Their control source is:
=[cboSelectWeeksOut].[Column](2)
Each source goes up in column number to associate with the correct column in
the combobox query.

Did I explain that correctly?


"Dirk Goldgar" wrote:

On Friday, October 09, 2009 3:41 PM
Dirk Goldgar wrote:

"jbreyare" wrote in message news:575ED334-
I believe so. Now, those text boxes that have their controlsources set to
expressions beginning with "=" are calculated controls, meaning that their
values are calculated as the result of an expression, and so are not
updatable. But your combo box itself, cboSelectWeeksOut, should not be a
calculated control. When you posted its controlsource before, you wrote:
"Control Source =[WeeksOut]". Did you mean that the equals sign ("=") was
part of the controlsource? If that is so, remove the equals sign to change
the controlsource to:

[WeeksOut]

Tell me if that makes the combo box updatable.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

On Friday, October 09, 2009 4:01 PM
jbreyare wrote:

Good catch. Althought I changed it and it did not make that combo box updateab
Good catch. Althought I changed it and it did not make that combo box
updateable.

"Dirk Goldgar" wrote:

On Friday, October 09, 2009 4:10 PM
jbreyare wrote:

I did also notice that when I take the "=" sign out and try to select a value f
I did also notice that when I take the "=" sign out and try to select a value
from the combo box the bottom left of the screen says "control cannot be
edited; its bound to unknow field '[WeeksOut]'.

Now I do not know why it is saying unknown field.

"Dirk Goldgar" wrote:

On Friday, October 09, 2009 4:21 PM
Dirk Goldgar wrote:

"jbreyare" wrote in message news:3432A3BB-
What is the form's RecordSource?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

On Friday, October 09, 2009 4:36 PM
jbreyare wrote:

West09 which is my Table"Dirk Goldgar" wrote:
West09 which is my Table

"Dirk Goldgar" wrote:

On Friday, October 09, 2009 4:44 PM
Dirk Goldgar wrote:

"jbreyare" wrote in message news:1454B9EE-
Please check the table's design view, and see whether "WeeksOut" -- spelled
exactly like that -- is the name of a field in the table. If it is not,
change the controlsource of the combo box on the form to the actual name of
the field.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

On Friday, October 09, 2009 5:28 PM
jbreyare wrote:

Ok, I think i'm changing how I am going to do this.The Combobox has values in i
Ok, I think i'm changing how I am going to do this.

The Combobox has values in it from 1-40 like it should ANd I am able to
select on them. However, when I select one of the values the other text
boxes in my form do not populate with any information. Ideally, i would like
to have that information bee filled in with the corresponding row values for
the combobox selection. On top of that I would like to be able to edit that
information and then update the table's corresponding rows. One problem I am
running inot is that when I select a value in the combobox and then enter
information into the other fields, it thinks I am trying to enter another
value into the combobox. I do not want another value, I want to update that
specific record.

"Dirk Goldgar" wrote:

EggHeadCafe - Software Developer Portal of Choice
ASP.NET Long Running Task in a Page with User Feedback
http://www.eggheadcafe.com/tutorials...ning-task.aspx