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.

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.

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.