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


J

Jeff Breyare

Access 2007
I have a combo box that shows all 40 selections inn it but it won't 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 can't seem to figure out what I'm missing here.

EggHeadCafe - Software Developer Portal of Choice
Accessing IIS Hosted WCF Services from PHP
http://www.eggheadcafe.com/tutorial...ba-e3c3295d8277/accessing-iis-hosted-wcf.aspx
 
Ad

Advertisements

D

Dirk Goldgar

Access 2007
I have a combo box that shows all 40 selections inn it but it won't 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 can't seem to figure out what I'm missing here.


Is your form itself updatable? Can you change the values of other bound
controls on the form?
 
J

jbreyare

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 aren't 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 said:
Access 2007
I have a combo box that shows all 40 selections inn it but it won't 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 can't seem to figure out what I'm missing here.


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)
 
D

Dirk Goldgar

jbreyare said:
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 aren't 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?

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's so, remove the equals sign to change
the controlsource to:

[WeeksOut]

Tell me if that makes the combo box updatable.
 
J

jbreyare

Good catch. Althought I changed it and it didn't make that combo box
updateable.

Dirk Goldgar said:
jbreyare said:
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 aren't 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?

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's 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)
 
J

jbreyare

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 don't know why it's saying unknown field.

Dirk Goldgar said:
jbreyare said:
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 aren't 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?

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's 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)
 
Ad

Advertisements

D

Dirk Goldgar

jbreyare said:
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 don't know why it's saying unknown field.


What is the form's RecordSource?
 
J

jbreyare

West09 which is my Table

Dirk Goldgar said:
jbreyare said:
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 don't know why it's saying unknown field.


What is the form's RecordSource?

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

(please reply to the newsgroup)
 
D

Dirk Goldgar

jbreyare said:
West09 which is my Table


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 isn't,
change the controlsource of the combo box on the form to the actual name of
the field.
 
J

jbreyare

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

The Combobox has values in it from 1-40 like it should ANd I'm 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'm
running inot is that when I select a value in the combobox and then enter
information into the other fields, it thinks I'm trying to enter another
value into the combobox. I don't want another value, I want to update that
specific record.
 
Ad

Advertisements

S

Shawn Lipsit

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 t
select on them. However, when I select one of the values the other tex
boxes in my form do not populate with any information. Ideally, i would lik
to have that information bee filled in with the corresponding row values fo
the combobox selection. On top of that I would like to be able to edit tha
information and then update the table's corresponding rows. One problem I a
running inot is that when I select a value in the combobox and then ente
information into the other fields, it thinks I am trying to enter anothe
value into the combobox. I do not want another value, I want to update tha
specific record

:

Previous Posts In This Thread:

Combo Box won't let me choose the values in it
Access 200
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 Shee
Control Source =[WeeksOut] This is my primary key adn the field I want the lookup to happen o
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/Quer
Bound Column =
Limit to List = Ye
Allow Value List Edits = Ye
Enabled = Ye
Locked = N
Auto Expand = Ye

I cannot seem to figure out what I am missing here

EggHeadCafe - Software Developer Portal of Choic
Accessing IIS Hosted WCF Services from PH
http://www.eggheadcafe.com/tutorial...ba-e3c3295d8277/accessing-iis-hosted-wcf.aspx

in message your
Is your form itself updatable? Can you change the values of other boun
controls on the form

-
Dirk Goldgar, MS Access MV
Access tips: www.datagnostics.com/tips.htm

(please reply to the newsgroup)

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 se
to return the value of each field based upon the criteria selected in th
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 i
the combobox query

Did I explain that correctly

:

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

[WeeksOut

Tell me if that makes the combo box updatable

-
Dirk Goldgar, MS Access MV
Access tips: www.datagnostics.com/tips.htm

(please reply to the newsgroup)

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 bo
updateable

:

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.

:

What is the form's RecordSource?

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

(please reply to the newsgroup)

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

:

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)

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.

:

EggHeadCafe - Software Developer Portal of Choice
ASP.NET Long Running Task in a Page with User Feedback
http://www.eggheadcafe.com/tutorial...c3-e937a350d77e/aspnet-long-running-task.aspx
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box not responsive 2
Combo box choice outcome 2
Can't choose data in combo box 1
Combo box won't let me select from the list 2
Same problem. 4
Combo box - adding entries 2
hello 2
Combo Box Query Value 3

Top