combo box value is not shown on the form

[Ira]

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.

 

[Douglas J. Steele]

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

 

[Ira]

Thank you, Douglas. It sounds like great idea. I will definitely try this.
Will let you know tomorrow how it worked. Thanks again!