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 |
#1
|
|||
|
|||
combo box value is not shown on the form
I have an continious form. There are two combo boxes. ComboBox1 is the
criteria for ComboBox2. Combo2 has 2 columns. First column ID(number)is bound, but second column NAME (text)is displayed. Works fine when I enter records. But after I close and reopen the form, nothing is shown in combo2. All the data entered previously exist in the table. RecordSource of Combo2 is a query. If I make this form as single form and put Requery command on Current event, it works. But i need to make it as continious, b/c it's subform. Thank you in advance. |
#2
|
|||
|
|||
combo box value is not shown on the form
Take a look at my February, 2006 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Ira" wrote in message ... I have an continious form. There are two combo boxes. ComboBox1 is the criteria for ComboBox2. Combo2 has 2 columns. First column ID(number)is bound, but second column NAME (text)is displayed. Works fine when I enter records. But after I close and reopen the form, nothing is shown in combo2. All the data entered previously exist in the table. RecordSource of Combo2 is a query. If I make this form as single form and put Requery command on Current event, it works. But i need to make it as continious, b/c it's subform. Thank you in advance. |
#3
|
|||
|
|||
combo box value is not shown on the form
Thank you, Douglas. It sounds like great idea. I will definitely try this.
Will let you know tomorrow how it worked. Thanks again! "Douglas J. Steele" wrote: Take a look at my February, 2006 "Access Answers" column in Pinnacle Publication's "Smart Access". You can download the column (and sample database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Ira" wrote in message ... I have an continious form. There are two combo boxes. ComboBox1 is the criteria for ComboBox2. Combo2 has 2 columns. First column ID(number)is bound, but second column NAME (text)is displayed. Works fine when I enter records. But after I close and reopen the form, nothing is shown in combo2. All the data entered previously exist in the table. RecordSource of Combo2 is a query. If I make this form as single form and put Requery command on Current event, it works. But i need to make it as continious, b/c it's subform. Thank you in advance. |
Thread Tools | |
Display Modes | |
|
|