Combo Box Problem
in [General]
|
Prev: excel 2000
Next: Raymond
From: Bob Vance on 5 Apr 2010 19:43 My Combo Box has no Control source and the Row Source type is Value List My Row Source is showing say 18;Dobbie,Chris Bound Column 1 My format is 3 column count 0cm:7cm;0cm but even if i try to show the last Column I am not getting "Chris" only when I click the arror do I see the name At the moment when I open my form I am getting just Dobbie and would like to get Dobbie, Chris -- Thanks in advance for any help with this......Bob MS Access 2007 accdb Windows XP Home Edition Ver 5.1 Service Pack 3
From: Jeff Boyce on 5 Apr 2010 20:01 Bob It sounds like you are expecting the combobox to display more than one column AFTER you've made your selection. That isn't how it works. If you want to see column 2 and column 3 after selection, you have a couple possibilities... One is to do away with column 3! Instead, use something like 18; "Dobbie, Chris". Or another would be to add a text box into which you have Access 'shove' that third column after selection. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message news:uUGxDnR1KHA.348(a)TK2MSFTNGP02.phx.gbl... > My Combo Box has no Control source and the Row Source type is Value List > My Row Source is showing say 18;Dobbie,Chris > Bound Column 1 > My format is 3 column count 0cm:7cm;0cm but even if i try to show the > last Column I am not getting "Chris" only when I click the arror do I see > the name > At the moment when I open my form I am getting just Dobbie and would like > to get Dobbie, Chris > > -- > Thanks in advance for any help with this......Bob > MS Access 2007 accdb > Windows XP Home Edition Ver 5.1 Service Pack 3 > >
From: Bob Vance on 5 Apr 2010 21:11 Thanks Jeff, my combo box cbOwnerName is being controlled by this! tblInvoice.OwnerName is correct Dobbie, Chris Regards Bob If CurrentProject.AllForms("frmMain").IsLoaded = True Then cbOwnerName.RowSource = Form_frmMain.cboClient & ";" & Form_frmMain.cboClient.Column(1) cbOwnerName.value = Forms!frmMain!cboClient.Column(1) recInvoice.Open "SELECT * FROM tblInvoice where OwnerName='" & cbOwnerName.value & "';", CurrentProject.Connection, adOpenDynamic, adLockOptimistic If recInvoice.BOF = False And recInvoice.EOF = False Then If recInvoice.Fields("OwnerAddress") = "" Or IsNull(recInvoice.Fields("OwnerAddress")) Then recInvoice.Fields("OwnerAddress") = "" Else tbAddress.value = recInvoice.Fields("OwnerAddress") End If End If cmdAdd_Click Else recInvoice.Open "SELECT * FROM tblInvoice where InvoiceID=" & Forms!frmMain!frmModifyInvoiceClientFromMain.Form!lstModify.value _ , CurrentProject.Connection, adOpenDynamic, adLockOptimistic subShowInvoiceValues subShowInvoiceDetailValues If CurrentProject.AllForms("frmMain").IsLoaded = True Then cbOwnerName.value = Form_frmMain.cboClient.value Else cbOwnerName.value = recInvoice.Fields("OwnerID") End If "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message news:ufC1HxR1KHA.2156(a)TK2MSFTNGP02.phx.gbl... > Bob > > It sounds like you are expecting the combobox to display more than one > column AFTER you've made your selection. That isn't how it works. > > If you want to see column 2 and column 3 after selection, you have a > couple possibilities... > > One is to do away with column 3! Instead, use something like 18; "Dobbie, > Chris". > > Or another would be to add a text box into which you have Access 'shove' > that third column after selection. > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message > news:uUGxDnR1KHA.348(a)TK2MSFTNGP02.phx.gbl... >> My Combo Box has no Control source and the Row Source type is Value List >> My Row Source is showing say 18;Dobbie,Chris >> Bound Column 1 >> My format is 3 column count 0cm:7cm;0cm but even if i try to show the >> last Column I am not getting "Chris" only when I click the arror do I see >> the name >> At the moment when I open my form I am getting just Dobbie and would like >> to get Dobbie, Chris >> >> -- >> Thanks in advance for any help with this......Bob >> MS Access 2007 accdb >> Windows XP Home Edition Ver 5.1 Service Pack 3 >> >> > >
From: Jeff Boyce on 6 Apr 2010 10:50 I don't see a question in this... I don't understand what you mean by "my combobox is being controlled by this... I thought you said the combobox was 'fed' by a value list... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message news:OdjQfYS1KHA.3412(a)TK2MSFTNGP05.phx.gbl... > Thanks Jeff, my combo box cbOwnerName is being controlled by this! > tblInvoice.OwnerName is correct Dobbie, Chris > Regards Bob > > If CurrentProject.AllForms("frmMain").IsLoaded = True Then > cbOwnerName.RowSource = Form_frmMain.cboClient & ";" & > Form_frmMain.cboClient.Column(1) > cbOwnerName.value = Forms!frmMain!cboClient.Column(1) > recInvoice.Open "SELECT * FROM tblInvoice where OwnerName='" & > cbOwnerName.value & "';", CurrentProject.Connection, adOpenDynamic, > adLockOptimistic > > If recInvoice.BOF = False And recInvoice.EOF = False Then > If recInvoice.Fields("OwnerAddress") = "" Or > IsNull(recInvoice.Fields("OwnerAddress")) Then > recInvoice.Fields("OwnerAddress") = "" > Else > tbAddress.value = recInvoice.Fields("OwnerAddress") > End If > End If > > cmdAdd_Click > > Else > recInvoice.Open "SELECT * FROM tblInvoice where InvoiceID=" & > Forms!frmMain!frmModifyInvoiceClientFromMain.Form!lstModify.value _ > , CurrentProject.Connection, adOpenDynamic, adLockOptimistic > subShowInvoiceValues > subShowInvoiceDetailValues > > If CurrentProject.AllForms("frmMain").IsLoaded = True Then > cbOwnerName.value = Form_frmMain.cboClient.value > Else > cbOwnerName.value = recInvoice.Fields("OwnerID") > End If > > "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message > news:ufC1HxR1KHA.2156(a)TK2MSFTNGP02.phx.gbl... >> Bob >> >> It sounds like you are expecting the combobox to display more than one >> column AFTER you've made your selection. That isn't how it works. >> >> If you want to see column 2 and column 3 after selection, you have a >> couple possibilities... >> >> One is to do away with column 3! Instead, use something like 18; >> "Dobbie, Chris". >> >> Or another would be to add a text box into which you have Access 'shove' >> that third column after selection. >> >> Regards >> >> Jeff Boyce >> Microsoft Access MVP >> >> -- >> Disclaimer: This author may have received products and services mentioned >> in this post. Mention and/or description of a product or service herein >> does not constitute endorsement thereof. >> >> Any code or pseudocode included in this post is offered "as is", with no >> guarantee as to suitability. >> >> You can thank the FTC of the USA for making this disclaimer >> possible/necessary. >> >> "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message >> news:uUGxDnR1KHA.348(a)TK2MSFTNGP02.phx.gbl... >>> My Combo Box has no Control source and the Row Source type is Value List >>> My Row Source is showing say 18;Dobbie,Chris >>> Bound Column 1 >>> My format is 3 column count 0cm:7cm;0cm but even if i try to show the >>> last Column I am not getting "Chris" only when I click the arror do I >>> see the name >>> At the moment when I open my form I am getting just Dobbie and would >>> like to get Dobbie, Chris >>> >>> -- >>> Thanks in advance for any help with this......Bob >>> MS Access 2007 accdb >>> Windows XP Home Edition Ver 5.1 Service Pack 3 >>> >>> >> >> > >
From: Bob Vance on 6 Apr 2010 14:18
Thanks Jeff it does have a Value List, but what ever way I change it I can not get Dobbie, Chris Only Dobbie So I assumed it must be a code controlling the Combo Box! It would have nothing to do with the case that opens the Form would it? DoCmd.OpenForm "frmInvoiceClient", , , , , , "ModifyOldInvoice" Regards Bob Vance "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message news:%23ggEFiZ1KHA.224(a)TK2MSFTNGP06.phx.gbl... >I don't see a question in this... > > I don't understand what you mean by "my combobox is being controlled by > this... I thought you said the combobox was 'fed' by a value list... > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message > news:OdjQfYS1KHA.3412(a)TK2MSFTNGP05.phx.gbl... >> Thanks Jeff, my combo box cbOwnerName is being controlled by this! >> tblInvoice.OwnerName is correct Dobbie, Chris >> Regards Bob >> >> If CurrentProject.AllForms("frmMain").IsLoaded = True Then >> cbOwnerName.RowSource = Form_frmMain.cboClient & ";" & >> Form_frmMain.cboClient.Column(1) >> cbOwnerName.value = Forms!frmMain!cboClient.Column(1) >> recInvoice.Open "SELECT * FROM tblInvoice where OwnerName='" & >> cbOwnerName.value & "';", CurrentProject.Connection, adOpenDynamic, >> adLockOptimistic >> >> If recInvoice.BOF = False And recInvoice.EOF = False Then >> If recInvoice.Fields("OwnerAddress") = "" Or >> IsNull(recInvoice.Fields("OwnerAddress")) Then >> recInvoice.Fields("OwnerAddress") = "" >> Else >> tbAddress.value = recInvoice.Fields("OwnerAddress") >> End If >> End If >> >> cmdAdd_Click >> >> Else >> recInvoice.Open "SELECT * FROM tblInvoice where InvoiceID=" & >> Forms!frmMain!frmModifyInvoiceClientFromMain.Form!lstModify.value _ >> , CurrentProject.Connection, adOpenDynamic, adLockOptimistic >> subShowInvoiceValues >> subShowInvoiceDetailValues >> >> If CurrentProject.AllForms("frmMain").IsLoaded = True Then >> cbOwnerName.value = Form_frmMain.cboClient.value >> Else >> cbOwnerName.value = recInvoice.Fields("OwnerID") >> End If >> >> "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message >> news:ufC1HxR1KHA.2156(a)TK2MSFTNGP02.phx.gbl... >>> Bob >>> >>> It sounds like you are expecting the combobox to display more than one >>> column AFTER you've made your selection. That isn't how it works. >>> >>> If you want to see column 2 and column 3 after selection, you have a >>> couple possibilities... >>> >>> One is to do away with column 3! Instead, use something like 18; >>> "Dobbie, Chris". >>> >>> Or another would be to add a text box into which you have Access 'shove' >>> that third column after selection. >>> >>> Regards >>> >>> Jeff Boyce >>> Microsoft Access MVP >>> >>> -- >>> Disclaimer: This author may have received products and services >>> mentioned >>> in this post. Mention and/or description of a product or service herein >>> does not constitute endorsement thereof. >>> >>> Any code or pseudocode included in this post is offered "as is", with no >>> guarantee as to suitability. >>> >>> You can thank the FTC of the USA for making this disclaimer >>> possible/necessary. >>> >>> "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message >>> news:uUGxDnR1KHA.348(a)TK2MSFTNGP02.phx.gbl... >>>> My Combo Box has no Control source and the Row Source type is Value >>>> List >>>> My Row Source is showing say 18;Dobbie,Chris >>>> Bound Column 1 >>>> My format is 3 column count 0cm:7cm;0cm but even if i try to show the >>>> last Column I am not getting "Chris" only when I click the arror do I >>>> see the name >>>> At the moment when I open my form I am getting just Dobbie and would >>>> like to get Dobbie, Chris >>>> >>>> -- >>>> Thanks in advance for any help with this......Bob >>>> MS Access 2007 accdb >>>> Windows XP Home Edition Ver 5.1 Service Pack 3 >>>> >>>> >>> >>> >> >> > > |