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 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/tutorials...osted-wcf.aspx

"Jeff Breyare" wrote in message ...
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)

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" wrote:

"Jeff Breyare" wrote in message ...
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)

"jbreyare" wrote in message
...
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)

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

"Dirk Goldgar" wrote:

"jbreyare" wrote in message
...
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)

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" wrote:

"jbreyare" wrote in message
...
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)

"jbreyare" wrote in message
...
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)

West09 which is my Table

"Dirk Goldgar" wrote:

"jbreyare" wrote in message
...
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)

"jbreyare" wrote in message
...
West09 which is my Table

"Dirk Goldgar" wrote:

What is the form's RecordSource?


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.

--
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'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.

"Dirk Goldgar" wrote:

"jbreyare" wrote in message
...
West09 which is my Table

"Dirk Goldgar" wrote:

What is the form's RecordSource?


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.

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

(please reply to the newsgroup)