If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Check form properties
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 |
|
Thread Tools | |
Display Modes | |
|
|