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