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" <(E-Mail Removed)> wrote in message
news:0AA5AB2D-3B5A-40CE-8614-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:0AA5AB2D-3B5A-40CE-8614-(E-Mail Removed)...
> >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.
> >
>
>
>